Pandas Profiling Report

Dataset statistics

Number of variables	111
Number of observations	39717
Missing cells	2263364
Missing cells (%)	51.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	33.6 MiB
Average record size in memory	888.0 B

Variable types

Numeric	25
Categorical	30
Boolean	2
Unsupported	54

Warnings

`pymnt_plan` has constant value "False"	Constant
`initial_list_status` has constant value "False"	Constant
`collections_12_mths_ex_med` has constant value "0.0"	Constant
`policy_code` has constant value "1"	Constant
`application_type` has constant value "INDIVIDUAL"	Constant
`acc_now_delinq` has constant value "0"	Constant
`chargeoff_within_12_mths` has constant value "0.0"	Constant
`delinq_amnt` has constant value "0"	Constant
`tax_liens` has constant value "0.0"	Constant
`int_rate` has a high cardinality: 371 distinct values	High cardinality
`emp_title` has a high cardinality: 28820 distinct values	High cardinality
`issue_d` has a high cardinality: 55 distinct values	High cardinality
`url` has a high cardinality: 39717 distinct values	High cardinality
`desc` has a high cardinality: 26527 distinct values	High cardinality
`title` has a high cardinality: 19615 distinct values	High cardinality
`zip_code` has a high cardinality: 823 distinct values	High cardinality
`earliest_cr_line` has a high cardinality: 526 distinct values	High cardinality
`revol_util` has a high cardinality: 1089 distinct values	High cardinality
`last_pymnt_d` has a high cardinality: 101 distinct values	High cardinality
`last_credit_pull_d` has a high cardinality: 106 distinct values	High cardinality
`id` is highly correlated with `member_id`	High correlation
`member_id` is highly correlated with `id`	High correlation
`loan_amnt` is highly correlated with `funded_amnt` and 2 other fields	High correlation
`funded_amnt` is highly correlated with `loan_amnt` and 3 other fields	High correlation
`funded_amnt_inv` is highly correlated with `loan_amnt` and 3 other fields	High correlation
`installment` is highly correlated with `loan_amnt` and 2 other fields	High correlation
`out_prncp` is highly correlated with `out_prncp_inv`	High correlation
`out_prncp_inv` is highly correlated with `out_prncp`	High correlation
`total_pymnt` is highly correlated with `funded_amnt` and 2 other fields	High correlation
`total_pymnt_inv` is highly correlated with `funded_amnt_inv` and 2 other fields	High correlation
`total_rec_prncp` is highly correlated with `total_pymnt` and 1 other fields	High correlation
`delinq_amnt` is highly correlated with `policy_code` and 20 other fields	High correlation
`policy_code` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`pub_rec` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`purpose` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`next_pymnt_d` is highly correlated with `delinq_amnt` and 10 other fields	High correlation
`initial_list_status` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`collections_12_mths_ex_med` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`application_type` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`verification_status` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`grade` is highly correlated with `delinq_amnt` and 9 other fields	High correlation
`pymnt_plan` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`acc_now_delinq` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`addr_state` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`sub_grade` is highly correlated with `delinq_amnt` and 9 other fields	High correlation
`emp_length` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`issue_d` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`term` is highly correlated with `delinq_amnt` and 9 other fields	High correlation
`home_ownership` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`chargeoff_within_12_mths` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`loan_status` is highly correlated with `delinq_amnt` and 9 other fields	High correlation
`tax_liens` is highly correlated with `delinq_amnt` and 20 other fields	High correlation
`pub_rec_bankruptcies` is highly correlated with `delinq_amnt` and 8 other fields	High correlation
`emp_title` has 2459 (6.2%) missing values	Missing
`emp_length` has 1075 (2.7%) missing values	Missing
`desc` has 12940 (32.6%) missing values	Missing
`mths_since_last_delinq` has 25682 (64.7%) missing values	Missing
`mths_since_last_record` has 36931 (93.0%) missing values	Missing
`next_pymnt_d` has 38577 (97.1%) missing values	Missing
`mths_since_last_major_derog` has 39717 (100.0%) missing values	Missing
`annual_inc_joint` has 39717 (100.0%) missing values	Missing
`dti_joint` has 39717 (100.0%) missing values	Missing
`verification_status_joint` has 39717 (100.0%) missing values	Missing
`tot_coll_amt` has 39717 (100.0%) missing values	Missing
`tot_cur_bal` has 39717 (100.0%) missing values	Missing
`open_acc_6m` has 39717 (100.0%) missing values	Missing
`open_il_6m` has 39717 (100.0%) missing values	Missing
`open_il_12m` has 39717 (100.0%) missing values	Missing
`open_il_24m` has 39717 (100.0%) missing values	Missing
`mths_since_rcnt_il` has 39717 (100.0%) missing values	Missing
`total_bal_il` has 39717 (100.0%) missing values	Missing
`il_util` has 39717 (100.0%) missing values	Missing
`open_rv_12m` has 39717 (100.0%) missing values	Missing
`open_rv_24m` has 39717 (100.0%) missing values	Missing
`max_bal_bc` has 39717 (100.0%) missing values	Missing
`all_util` has 39717 (100.0%) missing values	Missing
`total_rev_hi_lim` has 39717 (100.0%) missing values	Missing
`inq_fi` has 39717 (100.0%) missing values	Missing
`total_cu_tl` has 39717 (100.0%) missing values	Missing
`inq_last_12m` has 39717 (100.0%) missing values	Missing
`acc_open_past_24mths` has 39717 (100.0%) missing values	Missing
`avg_cur_bal` has 39717 (100.0%) missing values	Missing
`bc_open_to_buy` has 39717 (100.0%) missing values	Missing
`bc_util` has 39717 (100.0%) missing values	Missing
`mo_sin_old_il_acct` has 39717 (100.0%) missing values	Missing
`mo_sin_old_rev_tl_op` has 39717 (100.0%) missing values	Missing
`mo_sin_rcnt_rev_tl_op` has 39717 (100.0%) missing values	Missing
`mo_sin_rcnt_tl` has 39717 (100.0%) missing values	Missing
`mort_acc` has 39717 (100.0%) missing values	Missing
`mths_since_recent_bc` has 39717 (100.0%) missing values	Missing
`mths_since_recent_bc_dlq` has 39717 (100.0%) missing values	Missing
`mths_since_recent_inq` has 39717 (100.0%) missing values	Missing
`mths_since_recent_revol_delinq` has 39717 (100.0%) missing values	Missing
`num_accts_ever_120_pd` has 39717 (100.0%) missing values	Missing
`num_actv_bc_tl` has 39717 (100.0%) missing values	Missing
`num_actv_rev_tl` has 39717 (100.0%) missing values	Missing
`num_bc_sats` has 39717 (100.0%) missing values	Missing
`num_bc_tl` has 39717 (100.0%) missing values	Missing
`num_il_tl` has 39717 (100.0%) missing values	Missing
`num_op_rev_tl` has 39717 (100.0%) missing values	Missing
`num_rev_accts` has 39717 (100.0%) missing values	Missing
`num_rev_tl_bal_gt_0` has 39717 (100.0%) missing values	Missing
`num_sats` has 39717 (100.0%) missing values	Missing
`num_tl_120dpd_2m` has 39717 (100.0%) missing values	Missing
`num_tl_30dpd` has 39717 (100.0%) missing values	Missing
`num_tl_90g_dpd_24m` has 39717 (100.0%) missing values	Missing
`num_tl_op_past_12m` has 39717 (100.0%) missing values	Missing
`pct_tl_nvr_dlq` has 39717 (100.0%) missing values	Missing
`percent_bc_gt_75` has 39717 (100.0%) missing values	Missing
`pub_rec_bankruptcies` has 697 (1.8%) missing values	Missing
`tot_hi_cred_lim` has 39717 (100.0%) missing values	Missing
`total_bal_ex_mort` has 39717 (100.0%) missing values	Missing
`total_bc_limit` has 39717 (100.0%) missing values	Missing
`total_il_high_credit_limit` has 39717 (100.0%) missing values	Missing
`annual_inc` is highly skewed (γ1 = 30.9491846)	Skewed
`collection_recovery_fee` is highly skewed (γ1 = 25.02941842)	Skewed
`url` is uniformly distributed	Uniform
`id` has unique values	Unique
`member_id` has unique values	Unique
`url` has unique values	Unique
`mths_since_last_major_derog` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`annual_inc_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`dti_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`verification_status_joint` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_coll_amt` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_cur_bal` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_acc_6m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_6m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_il_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_rcnt_il` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bal_il` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`il_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_rv_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`open_rv_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`max_bal_bc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`all_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_rev_hi_lim` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`inq_fi` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_cu_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`inq_last_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`acc_open_past_24mths` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`avg_cur_bal` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`bc_open_to_buy` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`bc_util` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_old_il_acct` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_old_rev_tl_op` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_rcnt_rev_tl_op` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mo_sin_rcnt_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mort_acc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_bc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_bc_dlq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_inq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mths_since_recent_revol_delinq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_accts_ever_120_pd` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_actv_bc_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_actv_rev_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_bc_sats` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_bc_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_il_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_op_rev_tl` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_rev_accts` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_rev_tl_bal_gt_0` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_sats` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_120dpd_2m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_30dpd` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_90g_dpd_24m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_tl_op_past_12m` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`pct_tl_nvr_dlq` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`percent_bc_gt_75` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tot_hi_cred_lim` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bal_ex_mort` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_bc_limit` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_il_high_credit_limit` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`delinq_2yrs` has 35405 (89.1%) zeros	Zeros
`inq_last_6mths` has 19300 (48.6%) zeros	Zeros
`mths_since_last_delinq` has 443 (1.1%) zeros	Zeros
`mths_since_last_record` has 670 (1.7%) zeros	Zeros
`revol_bal` has 994 (2.5%) zeros	Zeros
`out_prncp` has 38577 (97.1%) zeros	Zeros
`out_prncp_inv` has 38577 (97.1%) zeros	Zeros
`total_rec_late_fee` has 37671 (94.8%) zeros	Zeros
`recoveries` has 35499 (89.4%) zeros	Zeros
`collection_recovery_fee` has 35935 (90.5%) zeros	Zeros

Reproduction

Analysis started	2021-04-14 05:47:44.569383
Analysis finished	2021-04-14 05:51:04.566598
Duration	3 minutes and 20 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	683131.9131
Minimum	54734
Maximum	1077501
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	54734
5-th percentile	372418.4
Q1	516221
median	665665
Q3	837755
95-th percentile	1039966.2
Maximum	1077501
Range	1022767
Interquartile range (IQR)	321534

Descriptive statistics

Standard deviation	210694.1329
Coefficient of variation (CV)	0.3084237889
Kurtosis	-0.7298893992
Mean	683131.9131
Median Absolute Deviation (MAD)	160026
Skewness	0.07880763188
Sum	2.713195019 × 10¹⁰
Variance	4.439201764 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
464899	1	< 0.1%
883418	1	< 0.1%
967373	1	< 0.1%
842446	1	< 0.1%
643791	1	< 0.1%
600784	1	< 0.1%
516313	1	< 0.1%
864979	1	< 0.1%
575175	1	< 0.1%
388774	1	< 0.1%
Other values (39707)	39707	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
54734	1	< 0.1%
55742	1	< 0.1%
57245	1	< 0.1%
57416	1	< 0.1%
58915	1	< 0.1%

Value	Count	Frequency (%)
1077501	1	< 0.1%
1077430	1	< 0.1%
1077175	1	< 0.1%
1076863	1	< 0.1%
1075358	1	< 0.1%

member_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	850463.5594
Minimum	70699
Maximum	1314167
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	70699
5-th percentile	388192.4
Q1	666780
median	850812
Q3	1047339
95-th percentile	1269461.8
Maximum	1314167
Range	1243468
Interquartile range (IQR)	380559

Descriptive statistics

Standard deviation	265678.3074
Coefficient of variation (CV)	0.3123923471
Kurtosis	-0.5629680132
Mean	850463.5594
Median Absolute Deviation (MAD)	190427
Skewness	-0.2124163719
Sum	3.377786119 × 10¹⁰
Variance	7.058496303 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
399649	1	< 0.1%
826287	1	< 0.1%
803517	1	< 0.1%
875198	1	< 0.1%
1069759	1	< 0.1%
697025	1	< 0.1%
1225411	1	< 0.1%
1278661	1	< 0.1%
692935	1	< 0.1%
522954	1	< 0.1%
Other values (39707)	39707	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70699	1	< 0.1%
73673	1	< 0.1%
74724	1	< 0.1%
76583	1	< 0.1%
80353	1	< 0.1%

Value	Count	Frequency (%)
1314167	1	< 0.1%
1313524	1	< 0.1%
1311748	1	< 0.1%
1311441	1	< 0.1%
1306957	1	< 0.1%

loan_amnt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	885
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11219.44381
Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	500
5-th percentile	2400
Q1	5500
median	10000
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9500

Descriptive statistics

Standard deviation	7456.670694
Coefficient of variation (CV)	0.6646203517
Kurtosis	0.7686685518
Mean	11219.44381
Median Absolute Deviation (MAD)	5000
Skewness	1.05931729
Sum	445602650
Variance	55601937.84
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2833	7.1%
12000	2334	5.9%
5000	2051	5.2%
6000	1908	4.8%
15000	1895	4.8%
20000	1626	4.1%
8000	1586	4.0%
25000	1390	3.5%
4000	1130	2.8%
3000	1030	2.6%
Other values (875)	21934	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
500	5	< 0.1%
700	1	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	1	< 0.1%

Value	Count	Frequency (%)
35000	679	1.7%
34800	2	< 0.1%
34675	1	< 0.1%
34525	1	< 0.1%
34475	5	< 0.1%

funded_amnt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1041
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10947.7132
Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	500
5-th percentile	2400
Q1	5400
median	9600
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9600

Descriptive statistics

Standard deviation	7187.23867
Coefficient of variation (CV)	0.6565059334
Kurtosis	0.9375519943
Mean	10947.7132
Median Absolute Deviation (MAD)	4600
Skewness	1.081710238
Sum	434810325
Variance	51656399.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2741	6.9%
12000	2244	5.6%
5000	2040	5.1%
6000	1898	4.8%
15000	1784	4.5%
8000	1573	4.0%
20000	1456	3.7%
25000	1133	2.9%
4000	1127	2.8%
3000	1022	2.6%
Other values (1031)	22699	57.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
500	5	< 0.1%
700	1	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	1	< 0.1%

Value	Count	Frequency (%)
35000	554	1.4%
34800	1	< 0.1%
34675	2	< 0.1%
34525	1	< 0.1%
34475	4	< 0.1%

funded_amnt_inv
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8205
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10397.44887
Minimum	0
Maximum	35000
Zeros	129
Zeros (%)	0.3%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1873.658
Q1	5000
median	8975
Q3	14400
95-th percentile	24736.57226
Maximum	35000
Range	35000
Interquartile range (IQR)	9400

Descriptive statistics

Standard deviation	7128.450439
Coefficient of variation (CV)	0.6855961044
Kurtosis	1.062544362
Mean	10397.44887
Median Absolute Deviation (MAD)	4200
Skewness	1.106212938
Sum	412955476.7
Variance	50814805.66
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	1309	3.3%
10000	1275	3.2%
6000	1200	3.0%
12000	1069	2.7%
8000	900	2.3%
4000	812	2.0%
3000	803	2.0%
15000	657	1.7%
7000	600	1.5%
2000	452	1.1%
Other values (8195)	30640	77.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	129	0.3%
0.000121098	1	< 0.1%
0.000531133	1	< 0.1%
0.000654607	1	< 0.1%
0.001867696	1	< 0.1%

Value	Count	Frequency (%)
35000	135	0.3%
34997.35245	1	< 0.1%
34993.65539	1	< 0.1%
34993.32571	1	< 0.1%
34993.26306	1	< 0.1%

term
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

36 months	29096
60 months	10621

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	397170
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36 months
2nd row	60 months
3rd row	36 months
4th row	36 months
5th row	60 months

Value	Count	Frequency (%)
36 months	29096	73.3%
60 months	10621	26.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
months	39717	50.0%
36	29096	36.6%
60	10621	13.4%

Most occurring characters

Value	Count	Frequency (%)
	79434	20.0%
6	39717	10.0%
m	39717	10.0%
o	39717	10.0%
n	39717	10.0%
t	39717	10.0%
h	39717	10.0%
s	39717	10.0%
3	29096	7.3%
0	10621	2.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	238302	60.0%
Space Separator	79434	20.0%
Decimal Number	79434	20.0%

Most frequent character per category

Value	Count	Frequency (%)
m	39717	16.7%
o	39717	16.7%
n	39717	16.7%
t	39717	16.7%
h	39717	16.7%
s	39717	16.7%

Value	Count	Frequency (%)
6	39717	50.0%
3	29096	36.6%
0	10621	13.4%

Value	Count	Frequency (%)
	79434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	238302	60.0%
Common	158868	40.0%

Most frequent character per script

Value	Count	Frequency (%)
m	39717	16.7%
o	39717	16.7%
n	39717	16.7%
t	39717	16.7%
h	39717	16.7%
s	39717	16.7%

Value	Count	Frequency (%)
	79434	50.0%
6	39717	25.0%
3	29096	18.3%
0	10621	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	397170	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	79434	20.0%
6	39717	10.0%
m	39717	10.0%
o	39717	10.0%
n	39717	10.0%
t	39717	10.0%
h	39717	10.0%
s	39717	10.0%
3	29096	7.3%
0	10621	2.7%

int_rate
Categorical

HIGH CARDINALITY

Distinct	371
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

10.99%	956
13.49%	826
11.49%	825
7.51%	787
7.88%	725
Other values (366)	35598

Length

Max length	6
Median length	6
Mean length	5.694287081
Min length	5

Characters and Unicode

Total characters	226160
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	< 0.1%

Sample

1st row	10.65%
2nd row	15.27%
3rd row	15.96%
4th row	13.49%
5th row	12.69%

Value	Count	Frequency (%)
10.99%	956	2.4%
13.49%	826	2.1%
11.49%	825	2.1%
7.51%	787	2.0%
7.88%	725	1.8%
7.49%	656	1.7%
11.71%	607	1.5%
9.99%	603	1.5%
7.90%	582	1.5%
5.42%	573	1.4%
Other values (361)	32577	82.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
10.99	956	2.4%
13.49	826	2.1%
11.49	825	2.1%
7.51	787	2.0%
7.88	725	1.8%
7.49	656	1.7%
11.71	607	1.5%
9.99	603	1.5%
7.90	582	1.5%
5.42	573	1.4%
Other values (361)	32577	82.0%

Most occurring characters

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	146726	64.9%
Other Punctuation	79434	35.1%

Most frequent character per category

Value	Count	Frequency (%)
1	38195	26.0%
9	21893	14.9%
2	12734	8.7%
7	12132	8.3%
6	12033	8.2%
4	11091	7.6%
5	9947	6.8%
3	9929	6.8%
8	9527	6.5%
0	9245	6.3%

Value	Count	Frequency (%)
.	39717	50.0%
%	39717	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	226160	100.0%

Most frequent character per script

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226160	100.0%

Most frequent character per block

Value	Count	Frequency (%)
.	39717	17.6%
%	39717	17.6%
1	38195	16.9%
9	21893	9.7%
2	12734	5.6%
7	12132	5.4%
6	12033	5.3%
4	11091	4.9%
5	9947	4.4%
3	9929	4.4%
Other values (2)	18772	8.3%

installment
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15383
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	324.5619221
Minimum	15.69
Maximum	1305.19
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	15.69
5-th percentile	71.246
Q1	167.02
median	280.22
Q3	430.78
95-th percentile	762.996
Maximum	1305.19
Range	1289.5
Interquartile range (IQR)	263.76

Descriptive statistics

Standard deviation	208.8748735
Coefficient of variation (CV)	0.6435593929
Kurtosis	1.246801303
Mean	324.5619221
Median Absolute Deviation (MAD)	123.2
Skewness	1.128419095
Sum	12890625.86
Variance	43628.71279
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
311.11	68	0.2%
180.96	59	0.1%
311.02	54	0.1%
150.8	48	0.1%
368.45	46	0.1%
372.12	45	0.1%
330.76	43	0.1%
339.31	42	0.1%
301.6	41	0.1%
317.72	41	0.1%
Other values (15373)	39230	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15.69	1	< 0.1%
16.08	1	< 0.1%
16.25	1	< 0.1%
16.31	1	< 0.1%
16.47	1	< 0.1%

Value	Count	Frequency (%)
1305.19	1	< 0.1%
1302.69	1	< 0.1%
1295.21	1	< 0.1%
1288.1	2	< 0.1%
1283.5	1	< 0.1%

grade
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

B	12020
A	10085
C	8098
D	5307
E	2842
Other values (2)	1365

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	C
3rd row	C
4th row	C
5th row	B

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
b	12020	30.3%
a	10085	25.4%
c	8098	20.4%
d	5307	13.4%
e	2842	7.2%
f	1049	2.6%
g	316	0.8%

Most occurring characters

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39717	100.0%

Most frequent character per category

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39717	100.0%

Most frequent character per script

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

sub_grade
Categorical

HIGH CORRELATION

Distinct	35
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

B3	2917
A4	2886
A5	2742
B5	2704
B4	2512
Other values (30)	25956

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	79434
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B2
2nd row	C4
3rd row	C5
4th row	C1
5th row	B5

Value	Count	Frequency (%)
B3	2917	7.3%
A4	2886	7.3%
A5	2742	6.9%
B5	2704	6.8%
B4	2512	6.3%
C1	2136	5.4%
B2	2057	5.2%
C2	2011	5.1%
B1	1830	4.6%
A3	1810	4.6%
Other values (25)	16112	40.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
b3	2917	7.3%
a4	2886	7.3%
a5	2742	6.9%
b5	2704	6.8%
b4	2512	6.3%
c1	2136	5.4%
b2	2057	5.2%
c2	2011	5.1%
b1	1830	4.6%
a3	1810	4.6%
Other values (25)	16112	40.6%

Most occurring characters

Value	Count	Frequency (%)
B	12020	15.1%
A	10085	12.7%
4	8293	10.4%
3	8215	10.3%
C	8098	10.2%
5	8070	10.2%
2	7907	10.0%
1	7232	9.1%
D	5307	6.7%
E	2842	3.6%
Other values (2)	1365	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39717	50.0%
Decimal Number	39717	50.0%

Most frequent character per category

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Value	Count	Frequency (%)
4	8293	20.9%
3	8215	20.7%
5	8070	20.3%
2	7907	19.9%
1	7232	18.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39717	50.0%
Common	39717	50.0%

Most frequent character per script

Value	Count	Frequency (%)
B	12020	30.3%
A	10085	25.4%
C	8098	20.4%
D	5307	13.4%
E	2842	7.2%
F	1049	2.6%
G	316	0.8%

Value	Count	Frequency (%)
4	8293	20.9%
3	8215	20.7%
5	8070	20.3%
2	7907	19.9%
1	7232	18.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79434	100.0%

Most frequent character per block

Value	Count	Frequency (%)
B	12020	15.1%
A	10085	12.7%
4	8293	10.4%
3	8215	10.3%
C	8098	10.2%
5	8070	10.2%
2	7907	10.0%
1	7232	9.1%
D	5307	6.7%
E	2842	3.6%
Other values (2)	1365	1.7%

emp_title
Categorical

HIGH CARDINALITY
MISSING

Distinct	28820
Distinct (%)	77.4%
Missing	2459
Missing (%)	6.2%
Memory size	310.4 KiB

US Army	134
Bank of America	109
IBM	66
AT&T	59
Kaiser Permanente	56
Other values (28815)	36834

Length

Max length	78
Median length	18
Mean length	18.37978421
Min length	2

Characters and Unicode

Total characters	684794
Distinct characters	96
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25641 ?
Unique (%)	68.8%

Sample

1st row	Ryder
2nd row	AIR RESOURCES BOARD
3rd row	University Medical Group
4th row	Veolia Transportaton
5th row	Southern Star Photography

Value	Count	Frequency (%)
US Army	134	0.3%
Bank of America	109	0.3%
IBM	66	0.2%
AT&T	59	0.1%
Kaiser Permanente	56	0.1%
Wells Fargo	54	0.1%
USAF	54	0.1%
UPS	53	0.1%
US Air Force	52	0.1%
Walmart	45	0.1%
Other values (28810)	36576	92.1%
(Missing)	2459	6.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	3197	3.2%
of	3008	3.0%
	1208	1.2%
and	963	1.0%
center	818	0.8%
bank	805	0.8%
county	803	0.8%
services	795	0.8%
school	750	0.7%
the	747	0.7%
Other values (18882)	87491	87.0%

Most occurring characters

Value	Count	Frequency (%)
	64766	9.5%
e	55954	8.2%
a	43836	6.4%
n	42641	6.2%
o	42586	6.2%
i	40491	5.9%
r	40067	5.9%
t	38580	5.6%
s	30254	4.4%
l	25923	3.8%
Other values (86)	259696	37.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	489338	71.5%
Uppercase Letter	119545	17.5%
Space Separator	64766	9.5%
Other Punctuation	8798	1.3%
Dash Punctuation	1031	0.2%
Decimal Number	968	0.1%
Open Punctuation	159	< 0.1%
Close Punctuation	156	< 0.1%
Math Symbol	21	< 0.1%
Other Symbol	2	< 0.1%
Other values (5)	10	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
C	14579	12.2%
S	13325	11.1%
A	8885	7.4%
I	7566	6.3%
M	6518	5.5%
P	6077	5.1%
T	5691	4.8%
L	5561	4.7%
E	5241	4.4%
D	5056	4.2%
Other values (18)	41046	34.3%

Value	Count	Frequency (%)
e	55954	11.4%
a	43836	9.0%
n	42641	8.7%
o	42586	8.7%
i	40491	8.3%
r	40067	8.2%
t	38580	7.9%
s	30254	6.2%
l	25923	5.3%
c	23099	4.7%
Other values (17)	105907	21.6%

Value	Count	Frequency (%)
.	4253	48.3%
,	2194	24.9%
&	1301	14.8%
'	652	7.4%
/	311	3.5%
#	36	0.4%
@	10	0.1%
:	9	0.1%
"	8	0.1%
!	8	0.1%
Other values (5)	16	0.2%

Value	Count	Frequency (%)
1	192	19.8%
2	161	16.6%
3	155	16.0%
0	98	10.1%
4	91	9.4%
5	72	7.4%
9	62	6.4%
6	58	6.0%
7	46	4.8%
8	33	3.4%

Value	Count	Frequency (%)
+	18	85.7%
\|	2	9.5%
<	1	4.8%

Value	Count	Frequency (%)
(	158	99.4%
[	1	0.6%

Value	Count	Frequency (%)
	1	50.0%
	1	50.0%

Value	Count	Frequency (%)
¢	1	50.0%
$	1	50.0%

Value	Count	Frequency (%)
	64766	100.0%

Value	Count	Frequency (%)
-	1031	100.0%

Value	Count	Frequency (%)
)	156	100.0%

Value	Count	Frequency (%)
©	2	100.0%

Value	Count	Frequency (%)
`	2	100.0%

Value	Count	Frequency (%)
_	2	100.0%

Value	Count	Frequency (%)
²	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	608883	88.9%
Common	75911	11.1%

Most frequent character per script

Value	Count	Frequency (%)
e	55954	9.2%
a	43836	7.2%
n	42641	7.0%
o	42586	7.0%
i	40491	6.7%
r	40067	6.6%
t	38580	6.3%
s	30254	5.0%
l	25923	4.3%
c	23099	3.8%
Other values (45)	225452	37.0%

Value	Count	Frequency (%)
	64766	85.3%
.	4253	5.6%
,	2194	2.9%
&	1301	1.7%
-	1031	1.4%
'	652	0.9%
/	311	0.4%
1	192	0.3%
2	161	0.2%
(	158	0.2%
Other values (31)	892	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	684780	> 99.9%
None	14	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	64766	9.5%
e	55954	8.2%
a	43836	6.4%
n	42641	6.2%
o	42586	6.2%
i	40491	5.9%
r	40067	5.9%
t	38580	5.6%
s	30254	4.4%
l	25923	3.8%
Other values (77)	259682	37.9%

Value	Count	Frequency (%)
Ã	3	21.4%
©	2	14.3%
Â	2	14.3%
²	2	14.3%
â	1	7.1%
	1	7.1%
¢	1	7.1%
	1	7.1%
¡	1	7.1%

emp_length
Categorical

HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	1075
Missing (%)	2.7%
Memory size	310.4 KiB

10+ years	8879
< 1 year	4583
2 years	4388
3 years	4095
4 years	3436
Other values (6)	13261

Length

Max length	9
Median length	7
Mean length	7.494306713
Min length	6

Characters and Unicode

Total characters	289595
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10+ years
2nd row	< 1 year
3rd row	10+ years
4th row	10+ years
5th row	1 year

Value	Count	Frequency (%)
10+ years	8879	22.4%
< 1 year	4583	11.5%
2 years	4388	11.0%
3 years	4095	10.3%
4 years	3436	8.7%
5 years	3282	8.3%
1 year	3240	8.2%
6 years	2229	5.6%
7 years	1773	4.5%
8 years	1479	3.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
years	30819	37.6%
10	8879	10.8%
1	7823	9.6%
year	7823	9.6%
	4583	5.6%
2	4388	5.4%
3	4095	5.0%
4	3436	4.2%
5	3282	4.0%
6	2229	2.7%
Other values (3)	4510	5.5%

Most occurring characters

Value	Count	Frequency (%)
	43225	14.9%
y	38642	13.3%
e	38642	13.3%
a	38642	13.3%
r	38642	13.3%
s	30819	10.6%
1	16702	5.8%
0	8879	3.1%
+	8879	3.1%
<	4583	1.6%
Other values (8)	21940	7.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	185387	64.0%
Decimal Number	47521	16.4%
Space Separator	43225	14.9%
Math Symbol	13462	4.6%

Most frequent character per category

Value	Count	Frequency (%)
1	16702	35.1%
0	8879	18.7%
2	4388	9.2%
3	4095	8.6%
4	3436	7.2%
5	3282	6.9%
6	2229	4.7%
7	1773	3.7%
8	1479	3.1%
9	1258	2.6%

Value	Count	Frequency (%)
y	38642	20.8%
e	38642	20.8%
a	38642	20.8%
r	38642	20.8%
s	30819	16.6%

Value	Count	Frequency (%)
+	8879	66.0%
<	4583	34.0%

Value	Count	Frequency (%)
	43225	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	185387	64.0%
Common	104208	36.0%

Most frequent character per script

Value	Count	Frequency (%)
	43225	41.5%
1	16702	16.0%
0	8879	8.5%
+	8879	8.5%
<	4583	4.4%
2	4388	4.2%
3	4095	3.9%
4	3436	3.3%
5	3282	3.1%
6	2229	2.1%
Other values (3)	4510	4.3%

Value	Count	Frequency (%)
y	38642	20.8%
e	38642	20.8%
a	38642	20.8%
r	38642	20.8%
s	30819	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	289595	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	43225	14.9%
y	38642	13.3%
e	38642	13.3%
a	38642	13.3%
r	38642	13.3%
s	30819	10.6%
1	16702	5.8%
0	8879	3.1%
+	8879	3.1%
<	4583	1.6%
Other values (8)	21940	7.6%

home_ownership
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

RENT	18899
MORTGAGE	17659
OWN	3058
OTHER	98
NONE	3

Length

Max length	8
Median length	4
Mean length	5.703955485
Min length	3

Characters and Unicode

Total characters	226544
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	RENT
3rd row	RENT
4th row	RENT
5th row	RENT

Value	Count	Frequency (%)
RENT	18899	47.6%
MORTGAGE	17659	44.5%
OWN	3058	7.7%
OTHER	98	0.2%
NONE	3	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
rent	18899	47.6%
mortgage	17659	44.5%
own	3058	7.7%
other	98	0.2%
none	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	226544	100.0%

Most frequent character per category

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	226544	100.0%

Most frequent character per script

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226544	100.0%

Most frequent character per block

Value	Count	Frequency (%)
E	36659	16.2%
R	36656	16.2%
T	36656	16.2%
G	35318	15.6%
N	21963	9.7%
O	20818	9.2%
M	17659	7.8%
A	17659	7.8%
W	3058	1.3%
H	98	< 0.1%

annual_inc
Real number (ℝ_≥0)

SKEWED

Distinct	5318
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	68968.92638
Minimum	4000
Maximum	6000000
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	4000
5-th percentile	24000
Q1	40404
median	59000
Q3	82300
95-th percentile	142000
Maximum	6000000
Range	5996000
Interquartile range (IQR)	41896

Descriptive statistics

Standard deviation	63793.76579
Coefficient of variation (CV)	0.9249638807
Kurtosis	2302.737777
Mean	68968.92638
Median Absolute Deviation (MAD)	20000
Skewness	30.9491846
Sum	2739238849
Variance	4069644554
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	1505	3.8%
50000	1057	2.7%
40000	876	2.2%
45000	830	2.1%
30000	825	2.1%
75000	811	2.0%
65000	803	2.0%
70000	733	1.8%
48000	723	1.8%
80000	662	1.7%
Other values (5308)	30892	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4000	1	< 0.1%
4080	1	< 0.1%
4200	2	< 0.1%
4800	4	< 0.1%
4888	1	< 0.1%

Value	Count	Frequency (%)
6000000	1	< 0.1%
3900000	1	< 0.1%
2039784	1	< 0.1%
1900000	1	< 0.1%
1782000	1	< 0.1%

verification_status
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Not Verified	16921
Verified	12809
Source Verified	9987

Length

Max length	15
Median length	12
Mean length	11.46433517
Min length	8

Characters and Unicode

Total characters	455329
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Verified
2nd row	Source Verified
3rd row	Not Verified
4th row	Source Verified
5th row	Source Verified

Value	Count	Frequency (%)
Not Verified	16921	42.6%
Verified	12809	32.3%
Source Verified	9987	25.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
verified	39717	59.6%
not	16921	25.4%
source	9987	15.0%

Most occurring characters

Value	Count	Frequency (%)
e	89421	19.6%
i	79434	17.4%
r	49704	10.9%
V	39717	8.7%
f	39717	8.7%
d	39717	8.7%
o	26908	5.9%
	26908	5.9%
N	16921	3.7%
t	16921	3.7%
Other values (3)	29961	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	361796	79.5%
Uppercase Letter	66625	14.6%
Space Separator	26908	5.9%

Most frequent character per category

Value	Count	Frequency (%)
e	89421	24.7%
i	79434	22.0%
r	49704	13.7%
f	39717	11.0%
d	39717	11.0%
o	26908	7.4%
t	16921	4.7%
u	9987	2.8%
c	9987	2.8%

Value	Count	Frequency (%)
V	39717	59.6%
N	16921	25.4%
S	9987	15.0%

Value	Count	Frequency (%)
	26908	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	428421	94.1%
Common	26908	5.9%

Most frequent character per script

Value	Count	Frequency (%)
e	89421	20.9%
i	79434	18.5%
r	49704	11.6%
V	39717	9.3%
f	39717	9.3%
d	39717	9.3%
o	26908	6.3%
N	16921	3.9%
t	16921	3.9%
S	9987	2.3%
Other values (2)	19974	4.7%

Value	Count	Frequency (%)
	26908	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455329	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	89421	19.6%
i	79434	17.4%
r	49704	10.9%
V	39717	8.7%
f	39717	8.7%
d	39717	8.7%
o	26908	5.9%
	26908	5.9%
N	16921	3.7%
t	16921	3.7%
Other values (3)	29961	6.6%

issue_d
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	55
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Dec-11	2260
Nov-11	2223
Oct-11	2114
Sep-11	2063
Aug-11	1928
Other values (50)	29129

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238302
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Dec-11
2nd row	Dec-11
3rd row	Dec-11
4th row	Dec-11
5th row	Dec-11

Value	Count	Frequency (%)
Dec-11	2260	5.7%
Nov-11	2223	5.6%
Oct-11	2114	5.3%
Sep-11	2063	5.2%
Aug-11	1928	4.9%
Jul-11	1870	4.7%
Jun-11	1827	4.6%
May-11	1689	4.3%
Apr-11	1562	3.9%
Mar-11	1443	3.6%
Other values (45)	20738	52.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
dec-11	2260	5.7%
nov-11	2223	5.6%
oct-11	2114	5.3%
sep-11	2063	5.2%
aug-11	1928	4.9%
jul-11	1870	4.7%
jun-11	1827	4.6%
may-11	1689	4.3%
apr-11	1562	3.9%
mar-11	1443	3.6%
Other values (45)	20738	52.2%

Most occurring characters

Value	Count	Frequency (%)
1	54844	23.0%
-	39717	16.7%
0	18061	7.6%
e	10439	4.4%
u	10273	4.3%
J	9134	3.8%
c	8367	3.5%
a	8070	3.4%
p	6482	2.7%
A	6352	2.7%
Other values (18)	66563	27.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79434	33.3%
Decimal Number	79434	33.3%
Uppercase Letter	39717	16.7%
Dash Punctuation	39717	16.7%

Most frequent character per category

Value	Count	Frequency (%)
e	10439	13.1%
u	10273	12.9%
c	8367	10.5%
a	8070	10.2%
p	6482	8.2%
n	5658	7.1%
r	5526	7.0%
o	4167	5.2%
v	4167	5.2%
t	3934	5.0%
Other values (4)	12351	15.5%

Value	Count	Frequency (%)
J	9134	23.0%
A	6352	16.0%
M	5691	14.3%
D	4433	11.2%
N	4167	10.5%
O	3934	9.9%
S	3648	9.2%
F	2358	5.9%

Value	Count	Frequency (%)
1	54844	69.0%
0	18061	22.7%
9	4716	5.9%
8	1562	2.0%
7	251	0.3%

Value	Count	Frequency (%)
-	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119151	50.0%
Common	119151	50.0%

Most frequent character per script

Value	Count	Frequency (%)
e	10439	8.8%
u	10273	8.6%
J	9134	7.7%
c	8367	7.0%
a	8070	6.8%
p	6482	5.4%
A	6352	5.3%
M	5691	4.8%
n	5658	4.7%
r	5526	4.6%
Other values (12)	43159	36.2%

Value	Count	Frequency (%)
1	54844	46.0%
-	39717	33.3%
0	18061	15.2%
9	4716	4.0%
8	1562	1.3%
7	251	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238302	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	54844	23.0%
-	39717	16.7%
0	18061	7.6%
e	10439	4.4%
u	10273	4.3%
J	9134	3.8%
c	8367	3.5%
a	8070	3.4%
p	6482	2.7%
A	6352	2.7%
Other values (18)	66563	27.9%

loan_status
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Fully Paid	32950
Charged Off	5627
Current	1140

Length

Max length	11
Median length	10
Mean length	10.05556814
Min length	7

Characters and Unicode

Total characters	399377
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Charged Off
3rd row	Fully Paid
4th row	Fully Paid
5th row	Current

Value	Count	Frequency (%)
Fully Paid	32950	83.0%
Charged Off	5627	14.2%
Current	1140	2.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
fully	32950	42.1%
paid	32950	42.1%
off	5627	7.2%
charged	5627	7.2%
current	1140	1.5%

Most occurring characters

Value	Count	Frequency (%)
l	65900	16.5%
	38577	9.7%
a	38577	9.7%
d	38577	9.7%
u	34090	8.5%
F	32950	8.3%
y	32950	8.3%
P	32950	8.3%
i	32950	8.3%
f	11254	2.8%
Other values (8)	40602	10.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	282506	70.7%
Uppercase Letter	78294	19.6%
Space Separator	38577	9.7%

Most frequent character per category

Value	Count	Frequency (%)
l	65900	23.3%
a	38577	13.7%
d	38577	13.7%
u	34090	12.1%
y	32950	11.7%
i	32950	11.7%
f	11254	4.0%
r	7907	2.8%
e	6767	2.4%
h	5627	2.0%
Other values (3)	7907	2.8%

Value	Count	Frequency (%)
F	32950	42.1%
P	32950	42.1%
C	6767	8.6%
O	5627	7.2%

Value	Count	Frequency (%)
	38577	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	360800	90.3%
Common	38577	9.7%

Most frequent character per script

Value	Count	Frequency (%)
l	65900	18.3%
a	38577	10.7%
d	38577	10.7%
u	34090	9.4%
F	32950	9.1%
y	32950	9.1%
P	32950	9.1%
i	32950	9.1%
f	11254	3.1%
r	7907	2.2%
Other values (7)	32695	9.1%

Value	Count	Frequency (%)
	38577	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	399377	100.0%

Most frequent character per block

Value	Count	Frequency (%)
l	65900	16.5%
	38577	9.7%
a	38577	9.7%
d	38577	9.7%
u	34090	8.5%
F	32950	8.3%
y	32950	8.3%
P	32950	8.3%
i	32950	8.3%
f	11254	2.8%
Other values (8)	40602	10.2%

pymnt_plan
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.9 KiB

False	39717

Common Values
Chart

Value	Count	Frequency (%)
False	39717	100.0%

url
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	39717
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

https://lendingclub.com/browse/loanDetail.action?loan_id=450292	1
https://lendingclub.com/browse/loanDetail.action?loan_id=665245	1
https://lendingclub.com/browse/loanDetail.action?loan_id=659209	1
https://lendingclub.com/browse/loanDetail.action?loan_id=180712	1
https://lendingclub.com/browse/loanDetail.action?loan_id=653306	1
Other values (39712)	39712

Length

Max length	64
Median length	63
Mean length	63.10836669
Min length	62

Characters and Unicode

Total characters	2506475
Distinct characters	35
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39717 ?
Unique (%)	100.0%

Sample

1st row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077501
2nd row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077430
3rd row	https://lendingclub.com/browse/loanDetail.action?loan_id=1077175
4th row	https://lendingclub.com/browse/loanDetail.action?loan_id=1076863
5th row	https://lendingclub.com/browse/loanDetail.action?loan_id=1075358

Value	Count	Frequency (%)
https://lendingclub.com/browse/loanDetail.action?loan_id=450292	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=665245	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=659209	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=180712	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=653306	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=831193	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=356431	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=463130	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=989294	1	< 0.1%
https://lendingclub.com/browse/loanDetail.action?loan_id=543973	1	< 0.1%
Other values (39707)	39707	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
https://lendingclub.com/browse/loandetail.action?loan_id=479864	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=657036	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=885629	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=652885	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=719484	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=865553	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=535721	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=970404	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=1065234	1	< 0.1%
https://lendingclub.com/browse/loandetail.action?loan_id=541026	1	< 0.1%
Other values (39707)	39707	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
l	198585	7.9%
n	198585	7.9%
o	198585	7.9%
t	158868	6.3%
/	158868	6.3%
i	158868	6.3%
a	158868	6.3%
e	119151	4.8%
c	119151	4.8%
s	79434	3.2%
Other values (25)	957512	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1826982	72.9%
Other Punctuation	317736	12.7%
Decimal Number	242606	9.7%
Uppercase Letter	39717	1.6%
Connector Punctuation	39717	1.6%
Math Symbol	39717	1.6%

Most frequent character per category

Value	Count	Frequency (%)
l	198585	10.9%
n	198585	10.9%
o	198585	10.9%
t	158868	8.7%
i	158868	8.7%
a	158868	8.7%
e	119151	6.5%
c	119151	6.5%
s	79434	4.3%
d	79434	4.3%
Other values (8)	357453	19.6%

Value	Count	Frequency (%)
5	26616	11.0%
6	26607	11.0%
7	26037	10.7%
8	25774	10.6%
4	25584	10.5%
1	24160	10.0%
0	23856	9.8%
3	22052	9.1%
9	21694	8.9%
2	20226	8.3%

Value	Count	Frequency (%)
/	158868	50.0%
.	79434	25.0%
:	39717	12.5%
?	39717	12.5%

Value	Count	Frequency (%)
D	39717	100.0%

Value	Count	Frequency (%)
_	39717	100.0%

Value	Count	Frequency (%)
=	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1866699	74.5%
Common	639776	25.5%

Most frequent character per script

Value	Count	Frequency (%)
l	198585	10.6%
n	198585	10.6%
o	198585	10.6%
t	158868	8.5%
i	158868	8.5%
a	158868	8.5%
e	119151	6.4%
c	119151	6.4%
s	79434	4.3%
d	79434	4.3%
Other values (9)	397170	21.3%

Value	Count	Frequency (%)
/	158868	24.8%
.	79434	12.4%
:	39717	6.2%
?	39717	6.2%
_	39717	6.2%
=	39717	6.2%
5	26616	4.2%
6	26607	4.2%
7	26037	4.1%
8	25774	4.0%
Other values (6)	137572	21.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2506475	100.0%

Most frequent character per block

Value	Count	Frequency (%)
l	198585	7.9%
n	198585	7.9%
o	198585	7.9%
t	158868	6.3%
/	158868	6.3%
i	158868	6.3%
a	158868	6.3%
e	119151	4.8%
c	119151	4.8%
s	79434	3.2%
Other values (25)	957512	38.2%

desc
Categorical

HIGH CARDINALITY
MISSING

Distinct	26527
Distinct (%)	99.1%
Missing	12940
Missing (%)	32.6%
Memory size	310.4 KiB

	210
Debt Consolidation	8
Camping Membership	6
credit card debt consolidation	3
personal loan	3
Other values (26522)	26547

Length

Max length	3988
Median length	285
Mean length	426.4940434
Min length	1

Characters and Unicode

Total characters	11420231
Distinct characters	142
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26499 ?
Unique (%)	99.0%

Sample

1st row	Borrower added on 12/22/11 > I need to upgrade my business technologies.<br>
2nd row	Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br>
3rd row	Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br>
4th row	Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br>
5th row	Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br>

Value	Count	Frequency (%)
	210	0.5%
Debt Consolidation	8	< 0.1%
Camping Membership	6	< 0.1%
credit card debt consolidation	3	< 0.1%
personal loan	3	< 0.1%
credit card consolidation	3	< 0.1%
Personal Loan	3	< 0.1%
consolidate credit cards	2	< 0.1%
I will use the loan and pay off all of my outstanding credit card debts that are spread out. It would be great to just focus on paying back one lender with a lower interest rate and not have to worry about keeping track each CC individually.	2	< 0.1%
Borrower added on 12/05/11 > Credit Card Refinancing<br>	2	< 0.1%
Other values (26517)	26535	66.8%
(Missing)	12940	32.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
i	77512	3.8%
to	71096	3.5%
a	54855	2.7%
the	54340	2.7%
and	54329	2.6%
my	51308	2.5%
on	49132	2.4%
	37238	1.8%
for	32774	1.6%
have	32490	1.6%
Other values (53986)	1535186	74.9%

Most occurring characters

Value	Count	Frequency (%)
	2121185	18.6%
e	953964	8.4%
a	714029	6.3%
o	709013	6.2%
t	649103	5.7%
n	612137	5.4%
r	589058	5.2%
i	496003	4.3%
s	426272	3.7%
d	397984	3.5%
Other values (132)	3751483	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8135704	71.2%
Space Separator	2121258	18.6%
Decimal Number	346663	3.0%
Other Punctuation	326744	2.9%
Uppercase Letter	302772	2.7%
Math Symbol	140645	1.2%
Currency Symbol	16745	0.1%
Dash Punctuation	13032	0.1%
Close Punctuation	7337	0.1%
Open Punctuation	6727	0.1%
Other values (7)	2604	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
I	94559	31.2%
B	34778	11.5%
T	28474	9.4%
A	15522	5.1%
C	14303	4.7%
M	14262	4.7%
S	9642	3.2%
E	9211	3.0%
W	8830	2.9%
L	8656	2.9%
Other values (21)	64535	21.3%

Value	Count	Frequency (%)
e	953964	11.7%
a	714029	8.8%
o	709013	8.7%
t	649103	8.0%
n	612137	7.5%
r	589058	7.2%
i	496003	6.1%
s	426272	5.2%
d	397984	4.9%
l	355636	4.4%
Other values (18)	2232505	27.4%

Value	Count	Frequency (%)
.	120658	36.9%
/	116441	35.6%
,	50144	15.3%
'	13317	4.1%
!	6738	2.1%
%	5704	1.7%
:	5281	1.6%
;	3357	1.0%
&	2616	0.8%
"	801	0.2%
Other values (10)	1687	0.5%

Value	Count	Frequency (%)
	1287	60.5%
	411	19.3%
	191	9.0%
	38	1.8%
	37	1.7%
	35	1.6%
	27	1.3%
	27	1.3%
	23	1.1%
	15	0.7%
Other values (9)	37	1.7%

Value	Count	Frequency (%)
0	104184	30.1%
1	97487	28.1%
2	36710	10.6%
5	21465	6.2%
3	17828	5.1%
9	16291	4.7%
4	13709	4.0%
6	13182	3.8%
7	12927	3.7%
8	12880	3.7%

Value	Count	Frequency (%)
>	84845	60.3%
<	53870	38.3%
+	984	0.7%
=	615	0.4%
~	290	0.2%
¬	31	< 0.1%
\|	10	< 0.1%

Value	Count	Frequency (%)
¦	96	83.5%
©	15	13.0%
®	2	1.7%
�	2	1.7%

Value	Count	Frequency (%)
(	6681	99.3%
[	44	0.7%
{	2	< 0.1%

Value	Count	Frequency (%)
)	7290	99.4%
]	44	0.6%
}	3	< 0.1%

Value	Count	Frequency (%)
-	13017	99.9%
—	9	0.1%
–	6	< 0.1%

Value	Count	Frequency (%)
`	13	68.4%
^	5	26.3%
¯	1	5.3%

Value	Count	Frequency (%)
	2121185	> 99.9%
	73	< 0.1%

Value	Count	Frequency (%)
$	16671	99.6%
¢	74	0.4%

Value	Count	Frequency (%)
½	6	75.0%
¾	2	25.0%

Value	Count	Frequency (%)
’	78	81.2%
”	18	18.8%

Value	Count	Frequency (%)
“	18	85.7%
‘	3	14.3%

Value	Count	Frequency (%)
_	217	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8438476	73.9%
Common	2981755	26.1%

Most frequent character per script

Value	Count	Frequency (%)
	2121185	71.1%
.	120658	4.0%
/	116441	3.9%
0	104184	3.5%
1	97487	3.3%
>	84845	2.8%
<	53870	1.8%
,	50144	1.7%
2	36710	1.2%
5	21465	0.7%
Other values (73)	174766	5.9%

Value	Count	Frequency (%)
e	953964	11.3%
a	714029	8.5%
o	709013	8.4%
t	649103	7.7%
n	612137	7.3%
r	589058	7.0%
i	496003	5.9%
s	426272	5.1%
d	397984	4.7%
l	355636	4.2%
Other values (49)	2535277	30.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11418236	> 99.9%
None	1834	< 0.1%
Punctuation	159	< 0.1%
Specials	2	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	2121185	18.6%
e	953964	8.4%
a	714029	6.3%
o	709013	6.2%
t	649103	5.7%
n	612137	5.4%
r	589058	5.2%
i	496003	4.3%
s	426272	3.7%
d	397984	3.5%
Other values (86)	3749488	32.8%

Value	Count	Frequency (%)
â	438	23.9%
	411	22.4%
	191	10.4%
Â	127	6.9%
Ã	97	5.3%
¦	96	5.2%
¢	74	4.0%
	73	4.0%
	38	2.1%
	37	2.0%
Other values (27)	252	13.7%

Value	Count	Frequency (%)
’	78	49.1%
…	19	11.9%
“	18	11.3%
”	18	11.3%
—	9	5.7%
•	8	5.0%
–	6	3.8%
‘	3	1.9%

Value	Count	Frequency (%)
�	2	100.0%

purpose
Categorical

HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

debt_consolidation	18641
credit_card	5130
other	3993
home_improvement	2976
major_purchase	2187
Other values (9)	6790

Length

Max length	18
Median length	16
Mean length	13.7361835
Min length	3

Characters and Unicode

Total characters	545560
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	car
3rd row	small_business
4th row	other
5th row	other

Value	Count	Frequency (%)
debt_consolidation	18641	46.9%
credit_card	5130	12.9%
other	3993	10.1%
home_improvement	2976	7.5%
major_purchase	2187	5.5%
small_business	1828	4.6%
car	1549	3.9%
wedding	947	2.4%
medical	693	1.7%
moving	583	1.5%
Other values (4)	1190	3.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	18641	46.9%
credit_card	5130	12.9%
other	3993	10.1%
home_improvement	2976	7.5%
major_purchase	2187	5.5%
small_business	1828	4.6%
car	1549	3.9%
wedding	947	2.4%
medical	693	1.7%
moving	583	1.5%
Other values (4)	1190	3.0%

Most occurring characters

Value	Count	Frequency (%)
o	69725	12.8%
d	50454	9.2%
i	50145	9.2%
t	50087	9.2%
n	44528	8.2%
e	43568	8.0%
c	34036	6.2%
a	33730	6.2%
_	30865	5.7%
s	28521	5.2%
Other values (12)	109901	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	514695	94.3%
Connector Punctuation	30865	5.7%

Most frequent character per category

Value	Count	Frequency (%)
o	69725	13.5%
d	50454	9.8%
i	50145	9.7%
t	50087	9.7%
n	44528	8.7%
e	43568	8.5%
c	34036	6.6%
a	33730	6.6%
s	28521	5.5%
l	23418	4.5%
Other values (11)	86483	16.8%

Value	Count	Frequency (%)
_	30865	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	514695	94.3%
Common	30865	5.7%

Most frequent character per script

Value	Count	Frequency (%)
o	69725	13.5%
d	50454	9.8%
i	50145	9.7%
t	50087	9.7%
n	44528	8.7%
e	43568	8.5%
c	34036	6.6%
a	33730	6.6%
s	28521	5.5%
l	23418	4.5%
Other values (11)	86483	16.8%

Value	Count	Frequency (%)
_	30865	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	545560	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	69725	12.8%
d	50454	9.2%
i	50145	9.2%
t	50087	9.2%
n	44528	8.2%
e	43568	8.0%
c	34036	6.2%
a	33730	6.2%
_	30865	5.7%
s	28521	5.2%
Other values (12)	109901	20.1%

title
Categorical

HIGH CARDINALITY

Distinct	19615
Distinct (%)	49.4%
Missing	11
Missing (%)	< 0.1%
Memory size	310.4 KiB

Debt Consolidation	2184
Debt Consolidation Loan	1729
Personal Loan	659
Consolidation	517
debt consolidation	505
Other values (19610)	34112

Length

Max length	80
Median length	16
Mean length	17.18732685
Min length	1

Characters and Unicode

Total characters	682440
Distinct characters	108
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17624 ?
Unique (%)	44.4%

Sample

1st row	Computer
2nd row	bike
3rd row	real estate business
4th row	personel
5th row	Personal

Value	Count	Frequency (%)
Debt Consolidation	2184	5.5%
Debt Consolidation Loan	1729	4.4%
Personal Loan	659	1.7%
Consolidation	517	1.3%
debt consolidation	505	1.3%
Credit Card Consolidation	356	0.9%
Home Improvement	356	0.9%
Debt consolidation	334	0.8%
Small Business Loan	328	0.8%
Credit Card Loan	317	0.8%
Other values (19605)	32421	81.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
loan	10895	10.4%
debt	9245	8.8%
consolidation	8622	8.2%
credit	4604	4.4%
card	3341	3.2%
personal	2043	2.0%
home	1875	1.8%
pay	1344	1.3%
off	1259	1.2%
my	1133	1.1%
Other values (8935)	60203	57.6%

Most occurring characters

Value	Count	Frequency (%)
	66029	9.7%
o	65729	9.6%
n	55657	8.2%
e	54557	8.0%
a	50167	7.4%
i	43822	6.4%
t	42600	6.2%
d	30679	4.5%
r	29153	4.3%
s	28544	4.2%
Other values (98)	215503	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	521300	76.4%
Uppercase Letter	83242	12.2%
Space Separator	66029	9.7%
Decimal Number	5995	0.9%
Other Punctuation	4442	0.7%
Dash Punctuation	824	0.1%
Connector Punctuation	213	< 0.1%
Close Punctuation	104	< 0.1%
Currency Symbol	94	< 0.1%
Math Symbol	92	< 0.1%
Other values (5)	105	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
C	18509	22.2%
L	10335	12.4%
D	9244	11.1%
P	5641	6.8%
R	3732	4.5%
M	3256	3.9%
S	3227	3.9%
B	3116	3.7%
H	2910	3.5%
I	2885	3.5%
Other values (18)	20387	24.5%

Value	Count	Frequency (%)
o	65729	12.6%
n	55657	10.7%
e	54557	10.5%
a	50167	9.6%
i	43822	8.4%
t	42600	8.2%
d	30679	5.9%
r	29153	5.6%
s	28544	5.5%
l	26300	5.0%
Other values (18)	94092	18.0%

Value	Count	Frequency (%)
!	1123	25.3%
'	982	22.1%
.	712	16.0%
/	538	12.1%
,	435	9.8%
&	328	7.4%
%	95	2.1%
:	64	1.4%
"	56	1.3%
#	25	0.6%
Other values (5)	84	1.9%

Value	Count	Frequency (%)
1	1691	28.2%
0	1677	28.0%
2	1105	18.4%
3	299	5.0%
5	256	4.3%
9	254	4.2%
4	216	3.6%
6	178	3.0%
8	169	2.8%
7	150	2.5%

Value	Count	Frequency (%)
	4	21.1%
	4	21.1%
	4	21.1%
	2	10.5%
	2	10.5%
	1	5.3%
	1	5.3%
	1	5.3%

Value	Count	Frequency (%)
+	53	57.6%
=	19	20.7%
<	9	9.8%
>	8	8.7%
~	2	2.2%
\|	1	1.1%

Value	Count	Frequency (%)
^	1	33.3%
´	1	33.3%
`	1	33.3%

Value	Count	Frequency (%)
(	77	96.2%
[	3	3.8%

Value	Count	Frequency (%)
)	100	96.2%
]	4	3.8%

Value	Count	Frequency (%)
	66029	100.0%

Value	Count	Frequency (%)
-	824	100.0%

Value	Count	Frequency (%)
_	213	100.0%

Value	Count	Frequency (%)
$	94	100.0%

Value	Count	Frequency (%)
³	1	100.0%

Value	Count	Frequency (%)
¦	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	604542	88.6%
Common	77898	11.4%

Most frequent character per script

Value	Count	Frequency (%)
o	65729	10.9%
n	55657	9.2%
e	54557	9.0%
a	50167	8.3%
i	43822	7.2%
t	42600	7.0%
d	30679	5.1%
r	29153	4.8%
s	28544	4.7%
l	26300	4.4%
Other values (46)	177334	29.3%

Value	Count	Frequency (%)
	66029	84.8%
1	1691	2.2%
0	1677	2.2%
!	1123	1.4%
2	1105	1.4%
'	982	1.3%
-	824	1.1%
.	712	0.9%
/	538	0.7%
,	435	0.6%
Other values (42)	2782	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	682408	> 99.9%
None	32	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	66029	9.7%
o	65729	9.6%
n	55657	8.2%
e	54557	8.0%
a	50167	7.4%
i	43822	6.4%
t	42600	6.2%
d	30679	4.5%
r	29153	4.3%
s	28544	4.2%
Other values (84)	215471	31.6%

Value	Count	Frequency (%)
â	4	12.5%
	4	12.5%
î	4	12.5%
	4	12.5%
	4	12.5%
Ã	2	6.2%
	2	6.2%
¦	2	6.2%
	1	3.1%
	1	3.1%
Other values (4)	4	12.5%

zip_code
Categorical

HIGH CARDINALITY

Distinct	823
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

100xx	597
945xx	545
112xx	516
606xx	503
070xx	473
Other values (818)	37083

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	198585
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	0.1%

Sample

1st row	860xx
2nd row	309xx
3rd row	606xx
4th row	917xx
5th row	972xx

Value	Count	Frequency (%)
100xx	597	1.5%
945xx	545	1.4%
112xx	516	1.3%
606xx	503	1.3%
070xx	473	1.2%
900xx	453	1.1%
021xx	397	1.0%
300xx	394	1.0%
926xx	371	0.9%
750xx	367	0.9%
Other values (813)	35101	88.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
100xx	597	1.5%
945xx	545	1.4%
112xx	516	1.3%
606xx	503	1.3%
070xx	473	1.2%
900xx	453	1.1%
021xx	397	1.0%
300xx	394	1.0%
926xx	371	0.9%
750xx	367	0.9%
Other values (813)	35101	88.4%

Most occurring characters

Value	Count	Frequency (%)
x	79434	40.0%
0	19773	10.0%
1	15629	7.9%
2	13589	6.8%
9	12681	6.4%
3	12356	6.2%
7	10257	5.2%
4	9121	4.6%
5	9020	4.5%
8	8670	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119151	60.0%
Lowercase Letter	79434	40.0%

Most frequent character per category

Value	Count	Frequency (%)
0	19773	16.6%
1	15629	13.1%
2	13589	11.4%
9	12681	10.6%
3	12356	10.4%
7	10257	8.6%
4	9121	7.7%
5	9020	7.6%
8	8670	7.3%
6	8055	6.8%

Value	Count	Frequency (%)
x	79434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119151	60.0%
Latin	79434	40.0%

Most frequent character per script

Value	Count	Frequency (%)
0	19773	16.6%
1	15629	13.1%
2	13589	11.4%
9	12681	10.6%
3	12356	10.4%
7	10257	8.6%
4	9121	7.7%
5	9020	7.6%
8	8670	7.3%
6	8055	6.8%

Value	Count	Frequency (%)
x	79434	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	198585	100.0%

Most frequent character per block

Value	Count	Frequency (%)
x	79434	40.0%
0	19773	10.0%
1	15629	7.9%
2	13589	6.8%
9	12681	6.4%
3	12356	6.2%
7	10257	5.2%
4	9121	4.6%
5	9020	4.5%
8	8670	4.4%

addr_state
Categorical

HIGH CORRELATION

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

CA	7099
NY	3812
FL	2866
TX	2727
NJ	1850
Other values (45)	21363

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	79434
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AZ
2nd row	GA
3rd row	IL
4th row	CA
5th row	OR

Value	Count	Frequency (%)
CA	7099	17.9%
NY	3812	9.6%
FL	2866	7.2%
TX	2727	6.9%
NJ	1850	4.7%
IL	1525	3.8%
PA	1517	3.8%
VA	1407	3.5%
GA	1398	3.5%
MA	1340	3.4%
Other values (40)	14176	35.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	7099	17.9%
ny	3812	9.6%
fl	2866	7.2%
tx	2727	6.9%
nj	1850	4.7%
il	1525	3.8%
pa	1517	3.8%
va	1407	3.5%
ga	1398	3.5%
ma	1340	3.4%
Other values (40)	14176	35.7%

Most occurring characters

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	79434	100.0%

Most frequent character per category

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	79434	100.0%

Most frequent character per script

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79434	100.0%

Most frequent character per block

Value	Count	Frequency (%)
A	15698	19.8%
C	10116	12.7%
N	7953	10.0%
L	5279	6.6%
M	4706	5.9%
Y	4220	5.3%
T	3892	4.9%
O	3451	4.3%
I	3097	3.9%
F	2866	3.6%
Other values (14)	18156	22.9%

dti
Real number (ℝ_≥0)

Distinct	2868
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.31512954
Minimum	0
Maximum	29.99
Zeros	183
Zeros (%)	0.5%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2.13
Q1	8.17
median	13.4
Q3	18.6
95-th percentile	23.84
Maximum	29.99
Range	29.99
Interquartile range (IQR)	10.43

Descriptive statistics

Standard deviation	6.678593595
Coefficient of variation (CV)	0.501579318
Kurtosis	-0.8520154806
Mean	13.31512954
Median Absolute Deviation (MAD)	5.21
Skewness	-0.02804333095
Sum	528837
Variance	44.6036124
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	183	0.5%
12	51	0.1%
18	45	0.1%
19.2	40	0.1%
13.2	39	0.1%
16.8	38	0.1%
12.48	38	0.1%
13.5	38	0.1%
6	37	0.1%
14.29	36	0.1%
Other values (2858)	39172	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	183	0.5%
0.01	3	< 0.1%
0.02	5	< 0.1%
0.03	2	< 0.1%
0.04	3	< 0.1%

Value	Count	Frequency (%)
29.99	1	< 0.1%
29.95	1	< 0.1%
29.93	3	< 0.1%
29.92	2	< 0.1%
29.89	1	< 0.1%

delinq_2yrs
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1465115694
Minimum	0
Maximum	11
Zeros	35405
Zeros (%)	89.1%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.491811516
Coefficient of variation (CV)	3.356810102
Kurtosis	39.41249957
Mean	0.1465115694
Median Absolute Deviation (MAD)	0
Skewness	5.022035213
Sum	5819
Variance	0.2418785673
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	35405	89.1%
1	3303	8.3%
2	687	1.7%
3	220	0.6%
4	62	0.2%
5	22	0.1%
6	10	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35405	89.1%
1	3303	8.3%
2	687	1.7%
3	220	0.6%
4	62	0.2%

Value	Count	Frequency (%)
11	1	< 0.1%
9	1	< 0.1%
8	2	< 0.1%
7	4	< 0.1%
6	10	< 0.1%

earliest_cr_line
Categorical

HIGH CARDINALITY

Distinct	526
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

Nov-98	370
Oct-99	366
Dec-98	348
Oct-00	346
Dec-97	329
Other values (521)	37958

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238302
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	0.1%

Sample

1st row	Jan-85
2nd row	Apr-99
3rd row	Nov-01
4th row	Feb-96
5th row	Jan-96

Value	Count	Frequency (%)
Nov-98	370	0.9%
Oct-99	366	0.9%
Dec-98	348	0.9%
Oct-00	346	0.9%
Dec-97	329	0.8%
Nov-00	320	0.8%
Nov-99	319	0.8%
Sep-00	306	0.8%
Oct-98	305	0.8%
Nov-97	298	0.8%
Other values (516)	36410	91.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
nov-98	370	0.9%
oct-99	366	0.9%
dec-98	348	0.9%
oct-00	346	0.9%
dec-97	329	0.8%
nov-00	320	0.8%
nov-99	319	0.8%
sep-00	306	0.8%
oct-98	305	0.8%
nov-97	298	0.8%
Other values (516)	36410	91.7%

Most occurring characters

Value	Count	Frequency (%)
-	39717	16.7%
9	23353	9.8%
0	19365	8.1%
e	10541	4.4%
J	9426	4.0%
u	9302	3.9%
a	9126	3.8%
8	8453	3.5%
c	8143	3.4%
n	6364	2.7%
Other values (23)	94512	39.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79434	33.3%
Decimal Number	79434	33.3%
Uppercase Letter	39717	16.7%
Dash Punctuation	39717	16.7%

Most frequent character per category

Value	Count	Frequency (%)
e	10541	13.3%
u	9302	11.7%
a	9126	11.5%
c	8143	10.3%
n	6364	8.0%
p	6335	8.0%
r	5536	7.0%
t	4076	5.1%
o	3930	4.9%
v	3930	4.9%
Other values (4)	12151	15.3%

Value	Count	Frequency (%)
9	23353	29.4%
0	19365	24.4%
8	8453	10.6%
7	4822	6.1%
4	4274	5.4%
5	4201	5.3%
6	4174	5.3%
3	3784	4.8%
1	3736	4.7%
2	3272	4.1%

Value	Count	Frequency (%)
J	9426	23.7%
A	6047	15.2%
M	5697	14.3%
O	4076	10.3%
D	4067	10.2%
N	3930	9.9%
S	3593	9.0%
F	2881	7.3%

Value	Count	Frequency (%)
-	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119151	50.0%
Common	119151	50.0%

Most frequent character per script

Value	Count	Frequency (%)
e	10541	8.8%
J	9426	7.9%
u	9302	7.8%
a	9126	7.7%
c	8143	6.8%
n	6364	5.3%
p	6335	5.3%
A	6047	5.1%
M	5697	4.8%
r	5536	4.6%
Other values (12)	42634	35.8%

Value	Count	Frequency (%)
-	39717	33.3%
9	23353	19.6%
0	19365	16.3%
8	8453	7.1%
7	4822	4.0%
4	4274	3.6%
5	4201	3.5%
6	4174	3.5%
3	3784	3.2%
1	3736	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238302	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	39717	16.7%
9	23353	9.8%
0	19365	8.1%
e	10541	4.4%
J	9426	4.0%
u	9302	3.9%
a	9126	3.8%
8	8453	3.5%
c	8143	3.4%
n	6364	2.7%
Other values (23)	94512	39.7%

inq_last_6mths
Real number (ℝ_≥0)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8691995871
Minimum	0
Maximum	8
Zeros	19300
Zeros (%)	48.6%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	3
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.070219332
Coefficient of variation (CV)	1.23126995
Kurtosis	2.562159858
Mean	0.8691995871
Median Absolute Deviation (MAD)	1
Skewness	1.390390927
Sum	34522
Variance	1.145369419
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	19300	48.6%
1	10971	27.6%
2	5812	14.6%
3	3048	7.7%
4	326	0.8%
5	146	0.4%
6	64	0.2%
7	35	0.1%
8	15	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	19300	48.6%
1	10971	27.6%
2	5812	14.6%
3	3048	7.7%
4	326	0.8%

Value	Count	Frequency (%)
8	15	< 0.1%
7	35	0.1%
6	64	0.2%
5	146	0.4%
4	326	0.8%

mths_since_last_delinq
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	95
Distinct (%)	0.7%
Missing	25682
Missing (%)	64.7%
Infinite	0
Infinite (%)	0.0%

Mean	35.90096188
Minimum	0
Maximum	120
Zeros	443
Zeros (%)	1.1%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	18
median	34
Q3	52
95-th percentile	75
Maximum	120
Range	120
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	22.02005955
Coefficient of variation (CV)	0.6133556984
Kurtosis	-0.8425777778
Mean	35.90096188
Median Absolute Deviation (MAD)	17
Skewness	0.3064368727
Sum	503870
Variance	484.8830224
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	443	1.1%
15	252	0.6%
23	247	0.6%
30	247	0.6%
24	241	0.6%
19	238	0.6%
38	237	0.6%
20	233	0.6%
22	231	0.6%
18	231	0.6%
Other values (85)	11435	28.8%
(Missing)	25682	64.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	443	1.1%
1	30	0.1%
2	101	0.3%
3	145	0.4%
4	153	0.4%

Value	Count	Frequency (%)
120	1	< 0.1%
115	1	< 0.1%
107	1	< 0.1%
106	1	< 0.1%
103	2	< 0.1%

mths_since_last_record
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	111
Distinct (%)	4.0%
Missing	36931
Missing (%)	93.0%
Infinite	0
Infinite (%)	0.0%

Mean	69.69813352
Minimum	0
Maximum	129
Zeros	670
Zeros (%)	1.7%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	90
Q3	104
95-th percentile	115
Maximum	129
Range	129
Interquartile range (IQR)	82

Descriptive statistics

Standard deviation	43.82252903
Coefficient of variation (CV)	0.6287475261
Kurtosis	-1.156555701
Mean	69.69813352
Median Absolute Deviation (MAD)	20
Skewness	-0.7172285764
Sum	194179
Variance	1920.41405
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	670	1.7%
104	61	0.2%
89	60	0.2%
113	59	0.1%
111	57	0.1%
94	55	0.1%
108	55	0.1%
87	54	0.1%
93	54	0.1%
100	53	0.1%
Other values (101)	1608	4.0%
(Missing)	36931	93.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	670	1.7%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
11	2	< 0.1%

Value	Count	Frequency (%)
129	1	< 0.1%
120	1	< 0.1%
119	10	< 0.1%
118	36	0.1%
117	47	0.1%

open_acc
Real number (ℝ_≥0)

Distinct	40
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.294407936
Minimum	2
Maximum	44
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	6
median	9
Q3	12
95-th percentile	17
Maximum	44
Range	42
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.400282474
Coefficient of variation (CV)	0.4734333272
Kurtosis	1.67757203
Mean	9.294407936
Median Absolute Deviation (MAD)	3
Skewness	1.00376191
Sum	369146
Variance	19.36248585
Monotocity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
7	4018	10.1%
6	3946	9.9%
8	3936	9.9%
9	3718	9.4%
10	3223	8.1%
5	3183	8.0%
11	2746	6.9%
4	2343	5.9%
12	2273	5.7%
13	1911	4.8%
Other values (30)	8420	21.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	605	1.5%
3	1493	3.8%
4	2343	5.9%
5	3183	8.0%
6	3946	9.9%

Value	Count	Frequency (%)
44	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%

pub_rec
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	37601
1	2056
2	51
3	7
4	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	37601	94.7%
1	2056	5.2%
2	51	0.1%
3	7	< 0.1%
4	2	< 0.1%

revol_bal
Real number (ℝ_≥0)

ZEROS

Distinct	21711
Distinct (%)	54.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13382.52809
Minimum	0
Maximum	149588
Zeros	994
Zeros (%)	2.5%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	321.8
Q1	3703
median	8850
Q3	17058
95-th percentile	41656.4
Maximum	149588
Range	149588
Interquartile range (IQR)	13355

Descriptive statistics

Standard deviation	15885.01664
Coefficient of variation (CV)	1.186996697
Kurtosis	14.89652278
Mean	13382.52809
Median Absolute Deviation (MAD)	6027
Skewness	3.190883683
Sum	531513868
Variance	252333753.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	994	2.5%
255	14	< 0.1%
298	14	< 0.1%
1	12	< 0.1%
682	11	< 0.1%
798	9	< 0.1%
346	9	< 0.1%
10	9	< 0.1%
865	9	< 0.1%
52	9	< 0.1%
Other values (21701)	38627	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	994	2.5%
1	12	< 0.1%
2	5	< 0.1%
3	6	< 0.1%
4	3	< 0.1%

Value	Count	Frequency (%)
149588	1	< 0.1%
149527	1	< 0.1%
149000	1	< 0.1%
148829	1	< 0.1%
148804	1	< 0.1%

revol_util
Categorical

HIGH CARDINALITY

Distinct	1089
Distinct (%)	2.7%
Missing	50
Missing (%)	0.1%
Memory size	310.4 KiB

0%	977
0.20%	63
63%	62
66.70%	58
0.10%	58
Other values (1084)	38449

Length

Max length	6
Median length	6
Mean length	5.521919984
Min length	2

Characters and Unicode

Total characters	219038
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	89 ?
Unique (%)	0.2%

Sample

1st row	83.70%
2nd row	9.40%
3rd row	98.50%
4th row	21%
5th row	53.90%

Value	Count	Frequency (%)
0%	977	2.5%
0.20%	63	0.2%
63%	62	0.2%
66.70%	58	0.1%
0.10%	58	0.1%
40.70%	58	0.1%
46.40%	57	0.1%
31.20%	57	0.1%
66.60%	57	0.1%
61%	57	0.1%
Other values (1079)	38163	96.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	977	2.5%
0.20	63	0.2%
63	62	0.2%
40.70	58	0.1%
0.10	58	0.1%
66.70	58	0.1%
66.60	57	0.1%
61	57	0.1%
31.20	57	0.1%
46.40	57	0.1%
Other values (1079)	38163	96.2%

Most occurring characters

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	144530	66.0%
Other Punctuation	74508	34.0%

Most frequent character per category

Value	Count	Frequency (%)
0	39671	27.4%
4	12082	8.4%
5	12063	8.3%
6	11989	8.3%
7	11949	8.3%
3	11885	8.2%
2	11550	8.0%
8	11419	7.9%
1	11111	7.7%
9	10811	7.5%

Value	Count	Frequency (%)
%	39667	53.2%
.	34841	46.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	219038	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	219038	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	39671	18.1%
%	39667	18.1%
.	34841	15.9%
4	12082	5.5%
5	12063	5.5%
6	11989	5.5%
7	11949	5.5%
3	11885	5.4%
2	11550	5.3%
8	11419	5.2%
Other values (2)	21922	10.0%

total_acc
Real number (ℝ_≥0)

Distinct	82
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.08882846
Minimum	2
Maximum	90
Zeros	0
Zeros (%)	0.0%
Memory size	310.4 KiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	13
median	20
Q3	29
95-th percentile	43
Maximum	90
Range	88
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.40170855
Coefficient of variation (CV)	0.5161753405
Kurtosis	0.6937402027
Mean	22.08882846
Median Absolute Deviation (MAD)	7
Skewness	0.8273790855
Sum	877302
Variance	129.9989579
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1471	3.7%
15	1462	3.7%
17	1457	3.7%
14	1445	3.6%
20	1428	3.6%
18	1422	3.6%
21	1412	3.6%
13	1385	3.5%
19	1341	3.4%
12	1325	3.3%
Other values (72)	25569	64.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	4	< 0.1%
3	182	0.5%
4	420	1.1%
5	552	1.4%
6	683	1.7%

Value	Count	Frequency (%)
90	1	< 0.1%
87	1	< 0.1%
81	1	< 0.1%
80	1	< 0.1%
79	2	< 0.1%

initial_list_status
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.9 KiB

False	39717

Common Values
Chart

Value	Count	Frequency (%)
False	39717	100.0%

out_prncp
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1137
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	51.2278873
Minimum	0
Maximum	6311.47
Zeros	38577
Zeros (%)	97.1%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6311.47
Range	6311.47
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	375.1728389
Coefficient of variation (CV)	7.323605532
Kurtosis	97.6585546
Mean	51.2278873
Median Absolute Deviation (MAD)	0
Skewness	9.226730006
Sum	2034618
Variance	140754.659
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	38577	97.1%
2277.11	2	< 0.1%
2963.24	2	< 0.1%
827.13	2	< 0.1%
1972.6	2	< 0.1%
1202.05	1	< 0.1%
4316.13	1	< 0.1%
3006.67	1	< 0.1%
1725.34	1	< 0.1%
743.52	1	< 0.1%
Other values (1127)	1127	2.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38577	97.1%
10.26	1	< 0.1%
11.91	1	< 0.1%
13.28	1	< 0.1%
19.12	1	< 0.1%

Value	Count	Frequency (%)
6311.47	1	< 0.1%
6308.37	1	< 0.1%
6307.37	1	< 0.1%
6307.15	1	< 0.1%
6219.16	1	< 0.1%

out_prncp_inv
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1138
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.98976811
Minimum	0
Maximum	6307.37
Zeros	38577
Zeros (%)	97.1%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6307.37
Range	6307.37
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	373.8244569
Coefficient of variation (CV)	7.331362169
Kurtosis	98.04055348
Mean	50.98976811
Median Absolute Deviation (MAD)	0
Skewness	9.243765495
Sum	2025160.62
Variance	139744.7246
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	38577	97.1%
1972.6	2	< 0.1%
827.13	2	< 0.1%
1664.64	2	< 0.1%
1212.39	1	< 0.1%
1662.57	1	< 0.1%
3335.41	1	< 0.1%
3131.63	1	< 0.1%
272.65	1	< 0.1%
87.94	1	< 0.1%
Other values (1128)	1128	2.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38577	97.1%
10.26	1	< 0.1%
11.91	1	< 0.1%
13.28	1	< 0.1%
19.09	1	< 0.1%

Value	Count	Frequency (%)
6307.37	1	< 0.1%
6306.96	1	< 0.1%
6298.11	1	< 0.1%
6276.75	1	< 0.1%
6219.16	1	< 0.1%

total_pymnt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	37850
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12153.59654
Minimum	0
Maximum	58563.67993
Zeros	16
Zeros (%)	< 0.1%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1887.957036
Q1	5576.93
median	9899.640319
Q3	16534.43304
95-th percentile	30245.11853
Maximum	58563.67993
Range	58563.67993
Interquartile range (IQR)	10957.50304

Descriptive statistics

Standard deviation	9042.040766
Coefficient of variation (CV)	0.743980659
Kurtosis	1.985894249
Mean	12153.59654
Median Absolute Deviation (MAD)	5016.756711
Skewness	1.339857366
Sum	482704393.9
Variance	81758501.21
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11196.56943	26	0.1%
0	16	< 0.1%
10956.77596	16	< 0.1%
11784.23223	16	< 0.1%
5478.387981	15	< 0.1%
13148.13786	15	< 0.1%
5557.025543	13	< 0.1%
13435.90021	13	< 0.1%
13263.95464	12	< 0.1%
14288.76169	11	< 0.1%
Other values (37840)	39564	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	< 0.1%
33.73	1	< 0.1%
35.71	1	< 0.1%
44.92	2	< 0.1%
44.96	1	< 0.1%

Value	Count	Frequency (%)
58563.67993	1	< 0.1%
58480.13992	1	< 0.1%
57835.27991	1	< 0.1%
56849.26986	1	< 0.1%
56662.58994	1	< 0.1%

total_pymnt_inv
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	37518
Distinct (%)	94.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11567.14912
Minimum	0
Maximum	58563.68
Zeros	165
Zeros (%)	0.4%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1420.408
Q1	5112.31
median	9287.15
Q3	15798.81
95-th percentile	29627.236
Maximum	58563.68
Range	58563.68
Interquartile range (IQR)	10686.5

Descriptive statistics

Standard deviation	8942.672613
Coefficient of variation (CV)	0.7731094777
Kurtosis	2.029758507
Mean	11567.14912
Median Absolute Deviation (MAD)	4939.58
Skewness	1.35483764
Sum	459412461.5
Variance	79971393.47
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	165	0.4%
6514.52	16	< 0.1%
5478.39	14	< 0.1%
13148.14	14	< 0.1%
6717.95	12	< 0.1%
10956.78	12	< 0.1%
11196.57	12	< 0.1%
5557.03	11	< 0.1%
7328.92	11	< 0.1%
13517.36	11	< 0.1%
Other values (37508)	39439	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	165	0.4%
0.54	1	< 0.1%
12.65	1	< 0.1%
18.97	1	< 0.1%
21.6	1	< 0.1%

Value	Count	Frequency (%)
58563.68	1	< 0.1%
58438.37	1	< 0.1%
57628.73	1	< 0.1%
56622.12	1	< 0.1%
56515.16	1	< 0.1%

total_rec_prncp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7976
Distinct (%)	20.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9793.348813
Minimum	0
Maximum	35000.02
Zeros	74
Zeros (%)	0.2%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1339.842
Q1	4600
median	8000
Q3	13653.26
95-th percentile	24999.982
Maximum	35000.02
Range	35000.02
Interquartile range (IQR)	9053.26

Descriptive statistics

Standard deviation	7065.522127
Coefficient of variation (CV)	0.7214612961
Kurtosis	1.103355455
Mean	9793.348813
Median Absolute Deviation (MAD)	4000
Skewness	1.118254546
Sum	388962434.8
Variance	49921602.93
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2293	5.8%
12000	1805	4.5%
5000	1702	4.3%
6000	1637	4.1%
15000	1400	3.5%
8000	1318	3.3%
20000	1059	2.7%
4000	956	2.4%
3000	883	2.2%
7000	851	2.1%
Other values (7966)	25813	65.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	74	0.2%
21.21	1	< 0.1%
21.93	1	< 0.1%
22.24	1	< 0.1%
22.5	1	< 0.1%

Value	Count	Frequency (%)
35000.02	2	< 0.1%
35000.01	1	< 0.1%
35000	363	0.9%
34999.99	5	< 0.1%
34999.98	1	< 0.1%

total_rec_int
Real number (ℝ_≥0)

Distinct	35148
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2263.663172
Minimum	0
Maximum	23563.68
Zeros	71
Zeros (%)	0.2%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	186.168
Q1	662.18
median	1348.91
Q3	2833.4
95-th percentile	7575.812
Maximum	23563.68
Range	23563.68
Interquartile range (IQR)	2171.22

Descriptive statistics

Standard deviation	2608.111964
Coefficient of variation (CV)	1.152164331
Kurtosis	9.688278395
Mean	2263.663172
Median Absolute Deviation (MAD)	866.01
Skewness	2.668747187
Sum	89905910.21
Variance	6802248.019
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71	0.2%
1196.57	26	0.1%
514.52	19	< 0.1%
1784.23	17	< 0.1%
717.95	17	< 0.1%
1148.14	17	< 0.1%
956.78	17	< 0.1%
478.39	16	< 0.1%
1907.35	14	< 0.1%
632.21	13	< 0.1%
Other values (35138)	39490	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	71	0.2%
6.22	1	< 0.1%
6.27	1	< 0.1%
7.19	1	< 0.1%
7.2	2	< 0.1%

Value	Count	Frequency (%)
23563.68	1	< 0.1%
23506.56	1	< 0.1%
23480.14	1	< 0.1%
22835.28	1	< 0.1%
22716.42	1	< 0.1%

total_rec_late_fee
Real number (ℝ_≥0)

ZEROS

Distinct	1356
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.363015212
Minimum	0
Maximum	180.2
Zeros	37671
Zeros (%)	94.8%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	14.924199
Maximum	180.2
Range	180.2
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.289979302
Coefficient of variation (CV)	5.348421085
Kurtosis	100.8515437
Mean	1.363015212
Median Absolute Deviation (MAD)	0
Skewness	8.429536
Sum	54134.87519
Variance	53.14379822
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37671	94.8%
15	255	0.6%
15.00000001	58	0.1%
30	55	0.1%
15.00000002	47	0.1%
14.99999999	40	0.1%
14.99999998	33	0.1%
15.00000003	32	0.1%
15.00000004	25	0.1%
14.99999997	25	0.1%
Other values (1346)	1476	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37671	94.8%
0.01	1	< 0.1%
0.060799751	1	< 0.1%
0.073787104	1	< 0.1%
0.101704562	1	< 0.1%

Value	Count	Frequency (%)
180.2	1	< 0.1%
166.4297107	1	< 0.1%
165.69	1	< 0.1%
146.6000003	1	< 0.1%
146.04	1	< 0.1%

recoveries
Real number (ℝ_≥0)

ZEROS

Distinct	4040
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	95.22162387
Minimum	0
Maximum	29623.35
Zeros	35499
Zeros (%)	89.4%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	362.418
Maximum	29623.35
Range	29623.35
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	688.744771
Coefficient of variation (CV)	7.23307105
Kurtosis	379.3775773
Mean	95.22162387
Median Absolute Deviation (MAD)	0
Skewness	16.5193782
Sum	3781917.235
Variance	474369.3595
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35499	89.4%
10.4	4	< 0.1%
11.29	4	< 0.1%
10.66	3	< 0.1%
13.59	3	< 0.1%
13.93	3	< 0.1%
164.81	3	< 0.1%
19.2	3	< 0.1%
10.07	3	< 0.1%
10.13	3	< 0.1%
Other values (4030)	4189	10.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35499	89.4%
6.3	1	< 0.1%
6.31	1	< 0.1%
8.19	1	< 0.1%
8.36	1	< 0.1%

Value	Count	Frequency (%)
29623.35	1	< 0.1%
22943.37	1	< 0.1%
21810.31	1	< 0.1%
20006.53	1	< 0.1%
19915.67	1	< 0.1%

collection_recovery_fee
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	2616
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.40611189
Minimum	0
Maximum	7002.19
Zeros	35935
Zeros (%)	90.5%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5.152
Maximum	7002.19
Range	7002.19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	148.6715935
Coefficient of variation (CV)	11.98373791
Kurtosis	821.3006591
Mean	12.40611189
Median Absolute Deviation (MAD)	0
Skewness	25.02941842
Sum	492733.5461
Variance	22103.2427
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35935	90.5%
2	12	< 0.1%
1.2	10	< 0.1%
3.71	9	< 0.1%
1.88	8	< 0.1%
0.8	8	< 0.1%
1.69	8	< 0.1%
1.21	8	< 0.1%
2.02	8	< 0.1%
1.6	8	< 0.1%
Other values (2606)	3703	9.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35935	90.5%
0.063	1	< 0.1%
0.074500001	1	< 0.1%
0.134799995	1	< 0.1%
0.1393	1	< 0.1%

Value	Count	Frequency (%)
7002.19	1	< 0.1%
6972.59	1	< 0.1%
6543.04	1	< 0.1%
5774.8	1	< 0.1%
5602.72	1	< 0.1%

last_pymnt_d
Categorical

HIGH CARDINALITY

Distinct	101
Distinct (%)	0.3%
Missing	71
Missing (%)	0.2%
Memory size	310.4 KiB

May-16	1256
Mar-13	1026
Dec-14	945
May-13	907
Feb-13	869
Other values (96)	34643

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	237876
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Jan-15
2nd row	Apr-13
3rd row	Jun-14
4th row	Jan-15
5th row	May-16

Value	Count	Frequency (%)
May-16	1256	3.2%
Mar-13	1026	2.6%
Dec-14	945	2.4%
May-13	907	2.3%
Feb-13	869	2.2%
Apr-13	851	2.1%
Mar-12	844	2.1%
Aug-14	832	2.1%
Jan-14	832	2.1%
Aug-12	832	2.1%
Other values (91)	30452	76.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
may-16	1256	3.2%
mar-13	1026	2.6%
dec-14	945	2.4%
may-13	907	2.3%
feb-13	869	2.2%
apr-13	851	2.1%
mar-12	844	2.1%
aug-12	832	2.1%
jan-14	832	2.1%
aug-14	832	2.1%
Other values (91)	30452	76.8%

Most occurring characters

Value	Count	Frequency (%)
1	43946	18.5%
-	39646	16.7%
a	11087	4.7%
e	9738	4.1%
3	9458	4.0%
u	9401	4.0%
4	9269	3.9%
J	9200	3.9%
2	8904	3.7%
M	8046	3.4%
Other values (22)	79181	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79292	33.3%
Decimal Number	79292	33.3%
Uppercase Letter	39646	16.7%
Dash Punctuation	39646	16.7%

Most frequent character per category

Value	Count	Frequency (%)
a	11087	14.0%
e	9738	12.3%
u	9401	11.9%
r	6965	8.8%
c	6783	8.6%
p	6219	7.8%
n	5974	7.5%
y	4285	5.4%
t	3271	4.1%
g	3242	4.1%
Other values (4)	12327	15.5%

Value	Count	Frequency (%)
1	43946	55.4%
3	9458	11.9%
4	9269	11.7%
2	8904	11.2%
0	2544	3.2%
5	2431	3.1%
6	2044	2.6%
9	559	0.7%
8	137	0.2%

Value	Count	Frequency (%)
J	9200	23.2%
M	8046	20.3%
A	6446	16.3%
D	3512	8.9%
O	3271	8.3%
F	3211	8.1%
S	3015	7.6%
N	2945	7.4%

Value	Count	Frequency (%)
-	39646	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118938	50.0%
Common	118938	50.0%

Most frequent character per script

Value	Count	Frequency (%)
a	11087	9.3%
e	9738	8.2%
u	9401	7.9%
J	9200	7.7%
M	8046	6.8%
r	6965	5.9%
c	6783	5.7%
A	6446	5.4%
p	6219	5.2%
n	5974	5.0%
Other values (12)	39079	32.9%

Value	Count	Frequency (%)
1	43946	36.9%
-	39646	33.3%
3	9458	8.0%
4	9269	7.8%
2	8904	7.5%
0	2544	2.1%
5	2431	2.0%
6	2044	1.7%
9	559	0.5%
8	137	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237876	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	43946	18.5%
-	39646	16.7%
a	11087	4.7%
e	9738	4.1%
3	9458	4.0%
u	9401	4.0%
4	9269	3.9%
J	9200	3.9%
2	8904	3.7%
M	8046	3.4%
Other values (22)	79181	33.3%

last_pymnt_amnt
Real number (ℝ_≥0)

Distinct	34930
Distinct (%)	87.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2678.826162
Minimum	0
Maximum	36115.2
Zeros	74
Zeros (%)	0.2%
Memory size	310.4 KiB

Quantile statistics

Minimum	0
5-th percentile	43.34
Q1	218.68
median	546.14
Q3	3293.16
95-th percentile	12183.944
Maximum	36115.2
Range	36115.2
Interquartile range (IQR)	3074.48

Descriptive statistics

Standard deviation	4447.136012
Coefficient of variation (CV)	1.660106234
Kurtosis	8.867819694
Mean	2678.826162
Median Absolute Deviation (MAD)	449.45
Skewness	2.712122241
Sum	106394938.7
Variance	19777018.71
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	74	0.2%
276.06	21	0.1%
200	17	< 0.1%
50	16	< 0.1%
100	15	< 0.1%
400	12	< 0.1%
773.44	12	< 0.1%
150	11	< 0.1%
786.01	11	< 0.1%
500	11	< 0.1%
Other values (34920)	39517	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	74	0.2%
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.13	1	< 0.1%

Value	Count	Frequency (%)
36115.2	1	< 0.1%
35613.68	1	< 0.1%
35596.41	1	< 0.1%
35479.89	1	< 0.1%
35471.86	1	< 0.1%

next_pymnt_d
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	0.2%
Missing	38577
Missing (%)	97.1%
Memory size	310.4 KiB

Jun-16	1125
Jul-16	15

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	6840
Distinct characters	7
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jun-16
2nd row	Jun-16
3rd row	Jun-16
4th row	Jun-16
5th row	Jun-16

Value	Count	Frequency (%)
Jun-16	1125	2.8%
Jul-16	15	< 0.1%
(Missing)	38577	97.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
jun-16	1125	98.7%
jul-16	15	1.3%

Most occurring characters

Value	Count	Frequency (%)
J	1140	16.7%
u	1140	16.7%
-	1140	16.7%
1	1140	16.7%
6	1140	16.7%
n	1125	16.4%
l	15	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2280	33.3%
Decimal Number	2280	33.3%
Uppercase Letter	1140	16.7%
Dash Punctuation	1140	16.7%

Most frequent character per category

Value	Count	Frequency (%)
u	1140	50.0%
n	1125	49.3%
l	15	0.7%

Value	Count	Frequency (%)
1	1140	50.0%
6	1140	50.0%

Value	Count	Frequency (%)
J	1140	100.0%

Value	Count	Frequency (%)
-	1140	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3420	50.0%
Common	3420	50.0%

Most frequent character per script

Value	Count	Frequency (%)
J	1140	33.3%
u	1140	33.3%
n	1125	32.9%
l	15	0.4%

Value	Count	Frequency (%)
-	1140	33.3%
1	1140	33.3%
6	1140	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6840	100.0%

Most frequent character per block

Value	Count	Frequency (%)
J	1140	16.7%
u	1140	16.7%
-	1140	16.7%
1	1140	16.7%
6	1140	16.7%
n	1125	16.4%
l	15	0.2%

last_credit_pull_d
Categorical

HIGH CARDINALITY

Distinct	106
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	310.4 KiB

May-16	10308
Apr-16	2547
Mar-16	1123
Feb-13	843
Feb-16	736
Other values (101)	24158

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	238290
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	May-16
2nd row	Sep-13
3rd row	May-16
4th row	Apr-16
5th row	May-16

Value	Count	Frequency (%)
May-16	10308	26.0%
Apr-16	2547	6.4%
Mar-16	1123	2.8%
Feb-13	843	2.1%
Feb-16	736	1.9%
Jan-16	657	1.7%
Dec-15	647	1.6%
Mar-13	577	1.5%
Mar-14	564	1.4%
Dec-14	562	1.4%
Other values (96)	21151	53.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
may-16	10308	26.0%
apr-16	2547	6.4%
mar-16	1123	2.8%
feb-13	843	2.1%
feb-16	736	1.9%
jan-16	657	1.7%
dec-15	647	1.6%
mar-13	577	1.5%
mar-14	564	1.4%
dec-14	562	1.4%
Other values (96)	21151	53.3%

Most occurring characters

Value	Count	Frequency (%)
1	41601	17.5%
-	39715	16.7%
a	17601	7.4%
M	15523	6.5%
6	15371	6.5%
y	12231	5.1%
r	7664	3.2%
e	7600	3.2%
p	6483	2.7%
A	6411	2.7%
Other values (23)	68090	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79430	33.3%
Decimal Number	79430	33.3%
Uppercase Letter	39715	16.7%
Dash Punctuation	39715	16.7%

Most frequent character per category

Value	Count	Frequency (%)
a	17601	22.2%
y	12231	15.4%
r	7664	9.6%
e	7600	9.6%
p	6483	8.2%
u	5856	7.4%
c	4475	5.6%
n	3834	4.8%
b	3075	3.9%
o	2225	2.8%
Other values (4)	8386	10.6%

Value	Count	Frequency (%)
1	41601	52.4%
6	15371	19.4%
4	6255	7.9%
5	5502	6.9%
3	5164	6.5%
2	4079	5.1%
0	1153	1.5%
9	228	0.3%
8	41	0.1%
7	36	< 0.1%

Value	Count	Frequency (%)
M	15523	39.1%
A	6411	16.1%
J	5895	14.8%
F	3075	7.7%
D	2414	6.1%
N	2225	5.6%
S	2111	5.3%
O	2061	5.2%

Value	Count	Frequency (%)
-	39715	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119145	50.0%
Common	119145	50.0%

Most frequent character per script

Value	Count	Frequency (%)
a	17601	14.8%
M	15523	13.0%
y	12231	10.3%
r	7664	6.4%
e	7600	6.4%
p	6483	5.4%
A	6411	5.4%
J	5895	4.9%
u	5856	4.9%
c	4475	3.8%
Other values (12)	29406	24.7%

Value	Count	Frequency (%)
1	41601	34.9%
-	39715	33.3%
6	15371	12.9%
4	6255	5.2%
5	5502	4.6%
3	5164	4.3%
2	4079	3.4%
0	1153	1.0%
9	228	0.2%
8	41	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238290	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	41601	17.5%
-	39715	16.7%
a	17601	7.4%
M	15523	6.5%
6	15371	6.5%
y	12231	5.1%
r	7664	3.2%
e	7600	3.2%
p	6483	2.7%
A	6411	2.7%
Other values (23)	68090	28.6%

collections_12_mths_ex_med
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	56
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39661

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	118983
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	39661	99.9%
(Missing)	56	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	39661	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79322	66.7%
Other Punctuation	39661	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	79322	100.0%

Value	Count	Frequency (%)
.	39661	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	118983	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118983	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

mths_since_last_major_derog
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

policy_code
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

1	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	39717	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	39717	100.0%

application_type
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

INDIVIDUAL	39717

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	397170
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDIVIDUAL
2nd row	INDIVIDUAL
3rd row	INDIVIDUAL
4th row	INDIVIDUAL
5th row	INDIVIDUAL

Value	Count	Frequency (%)
INDIVIDUAL	39717	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
individual	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	397170	100.0%

Most frequent character per category

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	397170	100.0%

Most frequent character per script

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	397170	100.0%

Most frequent character per block

Value	Count	Frequency (%)
I	119151	30.0%
D	79434	20.0%
N	39717	10.0%
V	39717	10.0%
U	39717	10.0%
A	39717	10.0%
L	39717	10.0%

annual_inc_joint
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

dti_joint
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

verification_status_joint
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

acc_now_delinq
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	39717	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	39717	100.0%

tot_coll_amt
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

tot_cur_bal
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_acc_6m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_6m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_12m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_il_24m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_rcnt_il
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bal_il
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

il_util
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_rv_12m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

open_rv_24m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

max_bal_bc
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

all_util
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_rev_hi_lim
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

inq_fi
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_cu_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

inq_last_12m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

acc_open_past_24mths
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

avg_cur_bal
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

bc_open_to_buy
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

bc_util
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

chargeoff_within_12_mths
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	56
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39661

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	118983
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	39661	99.9%
(Missing)	56	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	39661	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79322	66.7%
Other Punctuation	39661	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	79322	100.0%

Value	Count	Frequency (%)
.	39661	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	118983	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118983	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	79322	66.7%
.	39661	33.3%

delinq_amnt
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	310.4 KiB

0	39717

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	39717
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	39717	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39717	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	39717	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	39717	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39717	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	39717	100.0%

mo_sin_old_il_acct
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_old_rev_tl_op
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_rcnt_rev_tl_op
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mo_sin_rcnt_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mort_acc
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_bc
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_bc_dlq
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_inq
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

mths_since_recent_revol_delinq
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_accts_ever_120_pd
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_actv_bc_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_actv_rev_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_bc_sats
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_bc_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_il_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_op_rev_tl
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_rev_accts
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_rev_tl_bal_gt_0
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_sats
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_120dpd_2m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_30dpd
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_90g_dpd_24m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

num_tl_op_past_12m
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

pct_tl_nvr_dlq
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

percent_bc_gt_75
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

pub_rec_bankruptcies
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	697
Missing (%)	1.8%
Memory size	310.4 KiB

0.0	37339
1.0	1674
2.0	7

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	117060
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	37339	94.0%
1.0	1674	4.2%
2.0	7	< 0.1%
(Missing)	697	1.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	37339	95.7%
1.0	1674	4.3%
2.0	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	78040	66.7%
Other Punctuation	39020	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	76359	97.8%
1	1674	2.1%
2	7	< 0.1%

Value	Count	Frequency (%)
.	39020	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	117060	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117060	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	76359	65.2%
.	39020	33.3%
1	1674	1.4%
2	7	< 0.1%

tax_liens
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	39
Missing (%)	0.1%
Memory size	310.4 KiB

0.0	39678

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	119034
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	39678	99.9%
(Missing)	39	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	39678	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79356	66.7%
Other Punctuation	39678	33.3%

Most frequent character per category

Value	Count	Frequency (%)
0	79356	100.0%

Value	Count	Frequency (%)
.	39678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119034	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119034	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	79356	66.7%
.	39678	33.3%

tot_hi_cred_lim
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bal_ex_mort
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_bc_limit
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

total_il_high_credit_limit
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	39717
Missing (%)	100.0%
Memory size	310.4 KiB

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	member_id	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	grade	sub_grade	emp_title	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	pymnt_plan	url	desc	purpose	title	zip_code	addr_state	dti	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	mths_since_last_record	open_acc	revol_bal	revol_util	total_acc	initial_list_status	out_prncp	out_prncp_inv	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	total_rec_late_fee	recoveries	collection_recovery_fee	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	mths_since_last_major_derog	policy_code	application_type	annual_inc_joint	dti_joint	verification_status_joint	tot_coll_amt	tot_cur_bal	open_acc_6m	open_il_6m	open_il_12m	open_il_24m	mths_since_rcnt_il	total_bal_il	il_util	open_rv_12m	open_rv_24m	max_bal_bc	all_util	total_rev_hi_lim	inq_fi	total_cu_tl	inq_last_12m	acc_open_past_24mths	avg_cur_bal	bc_open_to_buy	bc_util	mo_sin_old_il_acct	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	mths_since_recent_bc	mths_since_recent_bc_dlq	mths_since_recent_inq	mths_since_recent_revol_delinq	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_120dpd_2m	num_tl_30dpd	num_tl_90g_dpd_24m	num_tl_op_past_12m	pct_tl_nvr_dlq	percent_bc_gt_75	tot_hi_cred_lim	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit
0	1077501	1296599	5000	5000	4,975.00	36 months	10.65%	162.87	B	B2	NaN	10+ years	RENT	24,000.00	Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077501	Borrower added on 12/22/11 > I need to upgrade my business technologies.<br>	credit_card	Computer	860xx	AZ	27.65	Jan-85	1	NaN	NaN	3	13648	83.70%	9	f	0.00	0.00	5,863.16	5,833.84	5,000.00	863.16	0.00	0.00	0.00	Jan-15	171.62	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	1077430	1314167	2500	2500	2,500.00	60 months	15.27%	59.83	C	C4	Ryder	< 1 year	RENT	30,000.00	Source Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077430	Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike. I only need this money because the deal im looking at is to good to pass up.<br><br> Borrower added on 12/22/11 > I plan to use this money to finance the motorcycle i am looking at. I plan to have it paid off as soon as possible/when i sell my old bike.I only need this money because the deal im looking at is to good to pass up. I have finished college with an associates degree in business and its takingmeplaces<br>	car	bike	309xx	GA	1.00	Apr-99	5	NaN	NaN	3	1687	9.40%	4	f	0.00	0.00	1,008.71	1,008.71	456.46	435.17	0.00	117.08	1.11	Apr-13	119.66	NaN	Sep-13	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	1077175	1313524	2400	2400	2,400.00	36 months	15.96%	84.33	C	C5	NaN	10+ years	RENT	12,252.00	Not Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1077175	NaN	small_business	real estate business	606xx	IL	8.72	Nov-01	2	NaN	NaN	2	2956	98.50%	10	f	0.00	0.00	3,005.67	3,005.67	2,400.00	605.67	0.00	0.00	0.00	Jun-14	649.91	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	1076863	1277178	10000	10000	10,000.00	36 months	13.49%	339.31	C	C1	AIR RESOURCES BOARD	10+ years	RENT	49,200.00	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1076863	Borrower added on 12/21/11 > to pay for property tax (borrow from friend, need to pay back) & central A/C need to be replace. I'm very sorry to let my loan expired last time.<br>	other	personel	917xx	CA	20.00	Feb-96	1	35.00	NaN	10	5598	21%	37	f	0.00	0.00	12,231.89	12,231.89	10,000.00	2,214.92	16.97	0.00	0.00	Jan-15	357.48	NaN	Apr-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	1075358	1311748	3000	3000	3,000.00	60 months	12.69%	67.79	B	B5	University Medical Group	1 year	RENT	80,000.00	Source Verified	Dec-11	Current	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1075358	Borrower added on 12/21/11 > I plan on combining three large interest bills together and freeing up some extra each month to pay toward other bills. I've always been a good payor but have found myself needing to make adjustments to my budget due to a medical scare. My job is very stable, I love it.<br>	other	Personal	972xx	OR	17.94	Jan-96	0	38.00	NaN	15	27783	53.90%	38	f	524.06	524.06	3,513.33	3,513.33	2,475.94	1,037.39	0.00	0.00	0.00	May-16	67.79	Jun-16	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	1075269	1311441	5000	5000	5,000.00	36 months	7.90%	156.46	A	A4	Veolia Transportaton	3 years	RENT	36,000.00	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1075269	NaN	wedding	My wedding loan I promise to pay back	852xx	AZ	11.20	Nov-04	3	NaN	NaN	9	7963	28.30%	12	f	0.00	0.00	5,632.21	5,632.21	5,000.00	632.21	0.00	0.00	0.00	Jan-15	161.03	NaN	Jan-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	1069639	1304742	7000	7000	7,000.00	60 months	15.96%	170.08	C	C5	Southern Star Photography	8 years	RENT	47,004.00	Not Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1069639	Borrower added on 12/18/11 > I am planning on using the funds to pay off two retail credit cards with 24.99% interest rates, as well as a major bank credit card with a 18.99% rate. I pay all my bills on time, looking for a lower combined payment and lower monthly payment.<br>	debt_consolidation	Loan	280xx	NC	23.51	Jul-05	1	NaN	NaN	7	17726	85.60%	11	f	0.00	0.00	10,110.84	10,110.84	6,985.61	3,125.23	0.00	0.00	0.00	May-16	1,313.76	NaN	May-16	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	1072053	1288686	3000	3000	3,000.00	36 months	18.64%	109.43	E	E1	MKC Accounting	9 years	RENT	48,000.00	Source Verified	Dec-11	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1072053	Borrower added on 12/16/11 > Downpayment for a car.<br>	car	Car Downpayment	900xx	CA	5.35	Jan-07	2	NaN	NaN	4	8221	87.50%	4	f	0.00	0.00	3,939.14	3,939.14	3,000.00	939.14	0.00	0.00	0.00	Jan-15	111.34	NaN	Dec-14	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	1071795	1306957	5600	5600	5,600.00	60 months	21.28%	152.39	F	F2	NaN	4 years	OWN	40,000.00	Source Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1071795	Borrower added on 12/21/11 > I own a small home-based judgment collection business. I have 5 years experience collecting debts. I am now going from a home office to a small office. I also plan to buy a small debt portfolio (eg. $10K for $1M of debt) <br>My score is not A+ because I own my home and have no mortgage.<br>	small_business	Expand Business & Buy Debt Portfolio	958xx	CA	5.55	Apr-04	2	NaN	NaN	11	5210	32.60%	13	f	0.00	0.00	646.02	646.02	162.02	294.94	0.00	189.06	2.09	Apr-12	152.39	NaN	Aug-12	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	1071570	1306721	5375	5375	5,350.00	60 months	12.69%	121.45	B	B5	Starbucks	< 1 year	RENT	15,000.00	Verified	Dec-11	Charged Off	n	https://lendingclub.com/browse/loanDetail.action?loan_id=1071570	Borrower added on 12/16/11 > I'm trying to build up my credit history. I live with my brother and have no car payment or credit cards. I am in community college and work full time. Im going to use the money to make some repairs around the house and get some maintenance done on my car.<br><br> Borrower added on 12/20/11 > $1000 down only $4375 to go. Thanks to everyone that invested so far, looking forward to surprising my brother with the fixes around the house.<br>	other	Building my credit history.	774xx	TX	18.08	Sep-04	0	NaN	NaN	2	9279	36.50%	3	f	0.00	0.00	1,476.19	1,469.34	673.48	533.42	0.00	269.29	2.52	Nov-12	121.45	NaN	Mar-13	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Last rows

	id	member_id	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	grade	sub_grade	emp_title	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	pymnt_plan	url	desc	purpose	title	zip_code	addr_state	dti	delinq_2yrs	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	mths_since_last_record	open_acc	pub_rec	revol_bal	revol_util	total_acc	initial_list_status	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	collections_12_mths_ex_med	mths_since_last_major_derog	policy_code	application_type	annual_inc_joint	dti_joint	verification_status_joint	tot_coll_amt	tot_cur_bal	open_acc_6m	open_il_6m	open_il_12m	open_il_24m	mths_since_rcnt_il	total_bal_il	il_util	open_rv_12m	open_rv_24m	max_bal_bc	all_util	total_rev_hi_lim	inq_fi	total_cu_tl	inq_last_12m	acc_open_past_24mths	avg_cur_bal	bc_open_to_buy	bc_util	chargeoff_within_12_mths	mo_sin_old_il_acct	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	mths_since_recent_bc	mths_since_recent_bc_dlq	mths_since_recent_inq	mths_since_recent_revol_delinq	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_120dpd_2m	num_tl_30dpd	num_tl_90g_dpd_24m	num_tl_op_past_12m	pct_tl_nvr_dlq	percent_bc_gt_75	pub_rec_bankruptcies	tax_liens	tot_hi_cred_lim	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit
39707	92666	92661	5000	5000	525.00	36 months	9.33%	159.77	B	B3	Stark and Roth Inc	2 years	MORTGAGE	180,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92666	Need a loan to make some home improvments	home_improvement	home improvment loan	530xx	WI	11.93	0	Feb-95	1	0.00	0.00	16	0	60568	39.20%	38	f	5,751.53	603.91	5,000.00	751.53	Jul-10	161.55	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39708	92552	92542	5000	5000	375.00	36 months	9.96%	161.25	B	B5	Millenium Group	4 years	MORTGAGE	48,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92552	I would like to pay off my high-interest credit card debts and have a single payment to make every month	debt_consolidation	Tito5000	333xx	FL	8.03	0	Aug-95	1	0.00	0.00	6	0	28329	48.60%	6	f	5,804.73	435.36	5,000.00	804.73	Jul-10	162.07	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39709	92533	92529	5000	5000	675.00	36 months	11.22%	164.23	C	C4	Self-Employeed	< 1 year	OWN	80,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92533	NaN	credit_card	P's Family Credit Loan	537xx	WI	1.21	0	Jul-96	3	0.00	44.00	15	1	27185	16.10%	29	f	5,912.05	798.13	5,000.00	912.05	Jul-10	165.17	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39710	92507	92502	5000	5000	250.00	36 months	7.43%	155.38	A	A2	Rush Univ Med Grp	1 year	OWN	85,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92507	NaN	credit_card	My Credit Card Loan	537xx	WI	0.31	0	Oct-97	0	0.00	0.00	7	0	216	0.60%	19	f	5,593.63	279.68	5,000.00	593.63	Jul-10	156.29	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39711	92402	92390	5000	5000	700.00	36 months	8.70%	158.30	B	B1	A. F. Wolfers, Inc.	5 years	MORTGAGE	75,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92402	I'd like to shift some credit card debt so it has a lower interest rate.	credit_card	Reduce Credit Card Debt	804xx	CO	15.55	0	May-94	0	0.00	0.00	10	0	66033	23%	29	f	5,698.60	797.80	5,000.00	698.60	Jul-10	159.83	NaN	Nov-14	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39712	92187	92174	2500	2500	1,075.00	36 months	8.07%	78.42	A	A4	FiSite Research	4 years	MORTGAGE	110,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=92187	Our current gutter system on our home is old and in need of repair. We will be using the borrowed funds to replace the gutter system on our home.	home_improvement	Home Improvement	802xx	CO	11.33	0	Nov-90	0	0.00	0.00	13	0	7274	13.10%	40	f	2,822.97	1,213.88	2,500.00	322.97	Jul-10	80.90	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39713	90665	90607	8500	8500	875.00	36 months	10.28%	275.38	C	C1	Squarewave Solutions, Ltd.	3 years	RENT	18,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90665	The rate of interest and fees incurred by carrying a balance on my credit card are so outrageous at this point that continuing to pay them is patently bad financial thinking. I wish to redirect my efforts at retiring my debt via another more-reasonable means. I have sufficient funds to direct to this end on a monthly basis, and have simply gotten tired of their being gobbled up by interest and fees.	credit_card	Retiring credit card debt	274xx	NC	6.40	1	Dec-86	1	5.00	0.00	6	0	8847	26.90%	9	f	9,913.49	1,020.51	8,500.00	1,413.49	Jul-10	281.94	NaN	Jul-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39714	90395	90390	5000	5000	1,325.00	36 months	8.07%	156.84	A	A4	NaN	< 1 year	MORTGAGE	100,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90395	NaN	debt_consolidation	MBA Loan Consolidation	017xx	MA	2.30	0	Oct-98	0	0.00	0.00	11	0	9698	19.40%	20	f	5,272.16	1,397.12	5,000.00	272.16	Apr-08	0.00	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39715	90376	89243	5000	5000	650.00	36 months	7.43%	155.38	A	A2	NaN	< 1 year	MORTGAGE	200,000.00	Not Verified	Jul-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=90376	NaN	other	JAL Loan	208xx	MD	3.72	0	Nov-88	0	0.00	0.00	17	0	85607	0.70%	26	f	5,174.20	672.66	5,000.00	174.20	Jan-08	0.00	NaN	Jun-07	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
39716	87023	86999	7500	7500	800.00	36 months	13.75%	255.43	E	E2	Evergreen Center	< 1 year	OWN	22,000.00	Not Verified	Jun-07	Fully Paid	n	https://lendingclub.com/browse/loanDetail.action?loan_id=87023	I plan to consolidate over $7,000 of debt: a combination of credit cards and student loans.	debt_consolidation	Consolidation Loan	027xx	MA	14.29	1	Oct-03	0	11.00	0.00	7	0	4175	51.50%	8	f	9,195.26	980.83	7,500.00	1,695.26	Jun-10	256.59	NaN	Jun-10	NaN	NaN	1	INDIVIDUAL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters